View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default what's the function to return a sheetname in a cell in Excel?

The workbook has to be saved first.

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

you can put that anywhere, even in A1

--


Regards,


Peo Sjoblom

"judi" wrote in message
...
I was hoping it was this, and it ain't.

=sheetname()

or

=sheet()