Referring to worksheet names in excel 1

[pete1001]

Everyone knows that you can refer to the worksheet name in headers & footers by using the &[TAB] function, but.... is it possible to do this in a cell? I can't figure it out - can anyone help?

Pete

 

[xlbo]

see my FAQ
faq68-2561

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[RoyVidar]

Hi xlbo!

That's a nice one I know I'm gonna use. Star for you!

Might I make a small suggestion? Consider adding to the faq that the workbook must be saved before FILENAME info is displayed. When browsing for interesting thingies, at least I, often do testing in unsaved books...

Roy-Vidar

 

[pete1001]

Thanks Geoff - that's great, I never knew that function existed!
If you hadn't been starred already, I'd star this time!!

 

[xlbo]

Roy - thanks for the suggestion - will add it in.

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244