The workbook needs to be saved
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)
You can put this in any cell, the formula needs a cell reference that is
what A1 does but it can be any cell
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
"Uggles" wrote in message
...
Is this an option? I want a cell on a worksheet to reference (copy) the
sheet
tab name.
Excel (Office 2003)