View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dias[_2_] Dias[_2_] is offline
external usenet poster
 
Posts: 6
Default Function With Lookup

Hi
I have a Workbook with a code that insert automatically a ws and fill
the name of that ws in a Master sheet in Column B with a link for that ws.

Wat I´m looking for is a function in row c to give me the value in A1 of
that ws.

In normal condition I can do CellC1=Sheet1!A1,is there a way to replace
"Sheet1" for the name of the sheet in column B

Thank you

Dias