Thread: how do I display the current worksheet name in a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default how do I display the current worksheet name in a cell?
The workbook has to be saved first

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

A1 is irrelevant in this case, what the formula needs is a single cell
reference, it can be any not just A1 and it can be put in any cell including
A1

--
Regards,

Peo Sjoblom



"JayJay" wrote in message
...
I want a function like =INFO() or =CELL() that returns the name of the
current worksheet, e.g. =CELL("WorkSheetName"). Is there such a function?


Reply With QuoteReply With Quote