Inserting Worksheet name in a cell

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I want to insert the worksheet name into a cell (not into
the header or footer).

I hjave found the INFO to do it for the directory and
other items but not for the worksheet name.

Is there any way to do this without a macro??

thanks.
 
one way:

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

Note: the file must be saved before this will work.
 
Workbook has to be saved

put this in any cell of the sheet

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)
 
Back
Top