Sheetname

M

monor

I want to show the sheetname in a cell. What formule/funtion to use?

Exampel: The sheet is named "Test". I want this name to appear in cell
A1.
 
P

Peo Sjoblom

The workbook must be saved

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