Thread: how do i name a excel worksheet and make it appear in cell a1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rowan Drummond
 
Posts: n/a
Default how do i name a excel worksheet and make it appear in cell a1
In A1 enter:
=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)

Hope this helps
Rowan

tthe wrote:
i want the name of the worksheet to appear in cell a1, and for it to change
if i change the sheet name. is this possible?
Reply With QuoteReply With Quote