Thread: Referencing the worksheet name in an excel function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Quietman Quietman is offline
external usenet poster
  
Posts: 109
Default Referencing the worksheet name in an excel function
Does anyone mknow how I would reference "Sheet2" to a cell in a worksheet
Need to be able to change the worksheet name based on a cell

Thanks

='C:\Documents and Settings\FP&A\Templates\[SMP2Data.xls]Sheet2'!$A$1
--
Helping Is always a good thing
Reply With QuoteReply With Quote