Inserting Worksheet name in a cell

[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.

 

[J.E. McGimpsey]

one way:

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

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

 

[Peo Sjoblom]

Workbook has to be saved

put this in any cell of the sheet

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