Show the Worksheet Tab Name in a Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
This formula should work once the file has been saved --

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

Rgds,
Andy
 
Back
Top