Display Tab Name on Sheet

echovue · January 13th, 2005, 07:07 PM

Does anyone know if there is a way to display the name of the tab within a cell in a spread sheet. Like you can put &[tab] in a header to display it?

Thanks in advance

Mike

Mike
EchoVue.com

amjad_mahmood · January 14th, 2005, 02:49 AM

Yes!

Goto the cell where u need this to happen
type the formula =Tabname()
This will at first cause an error
now press Alt+F11 to goto VBA editor
Insert a new module

type these three lines there!

Function tabname()
tabname = ActiveSheet.Name
End Function

goto the cell again

ReCalc [or F9)

that's it!

regards
Amjad Mahmood

echovue · January 14th, 2005, 10:45 AM

Works great!! Thanks

Mike
EchoVue.com