Workbook needs to be saved first


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

Peo Sjoblom


"anonymous" wrote in message
...
What's the formula to put the sheet name into a cell?

Thank you,

MB