Return Tab Name

[oldblindpew]

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,

 

[Peo Sjoblom]

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

 

[T. Valko]

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.

 

[Yahya Al-Tawil]

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