Show the Worksheet Tab Name in a Cell

I

Ish

Is there a function that allows the worksheet name to be shown in a cell. For example, say the worksheet name is "Totals", is it possible to have this display in one of the cells without having to type it in.
 
A

Andy Brown

This formula should work once the file has been saved --

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

Rgds,
Andy
 
Top