Thread: How do I reference a worksheet name through a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default How do I reference a worksheet name through a formula?
Check out the Indirect function.

Regards,
Fred

"pv6901" wrote in message
...
I would like to reference a cell to obtain a worksheet name rather than
have
the worksheet name in the formula. So rather than have Sheet1! in the
formula
I would like to have a cell that contains the text "Sheet1"

Reply With QuoteReply With Quote