show sheet name in cell

[cmunnelly]

I want to show the current sheet name in cell A1. I guess this is possible if anyone can point me in the right direction

 

[Loomah]

Hi
Have a look at this thread thread68-589959

Happy Friday
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[klmorgan]

Hi

Enter
=CELL("filename&quot

in A1

Keith

 

[Loomah]

Keith
That would only take you part of the way there as that formula will display the full path and file name including sheet.

Anyway, just discovered there is a FAQ on this!!

faq68-2561

Hoppy Friday
;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[cmunnelly]

sorted it. thanks for the help