Return Tab Name
 

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,

Return Tab Name
 

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,

Return Tab Name
 

Try this:

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

The file must have been saved at least once for that to work.

--
Biff
Microsoft Excel MVP


"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,

Return Tab Name
 

i think You you can use this UDF
Function SheetName()
SheetName = Application.Caller.Parent.Name
End Function