Thread: Cell display worksheet title
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 299
Default Cell display worksheet title
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)


will give you the sheet name, the workbook needs to be saved before this
formula works correctly


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)



"Jim Marchiori" <Jim wrote in message
...
How can I make a cell display the title of a worksheet, so that when I
change
the name on a worksheet tab, the cell changes with it?


Reply With QuoteReply With Quote