Hi,
In the cell where you want the tab name enter

=MID(CELL("filename",C1),FIND("]",CELL("filename",C1))+1,255)

if this helps please click yes, thanks

"MRO" wrote:

Hi
Is there a way I can reference a cell to look at the tab name only?
&[TAB] in footer but I want it visible in a cell