Try this


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


Note that the workbook needs to be saved and don't replace filename with the
name of the file, it is part of this function

--


Regards,


Peo Sjoblom


"oldblindpew" wrote in message
...
I haven't been able to find a function that returns the name of a worksheet
tab. In custom headers, the tab is referenced by &[TAB] but this doesn't
work as a cell formula. Is there any way to do it?
Thanks,