How can I cause a cell to return the sheet name i.e. sheet 1?

Matt · Feb 15, 2005

I just want the cell to give the title of the sheet. For example: Sheet 1
would be displayed in A2 if A2 had this function.

JE McGimpsey · Feb 15, 2005

Take a look here:

http://www.mcgimpsey.com/excel/

Matt said:
I just want the cell to give the title of the sheet. For example: Sheet 1
would be displayed in A2 if A2 had this function.

Peo Sjoblom · Feb 15, 2005

One way

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

you need to have saved the workbook