Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

show sheet name in cell

Status
Not open for further replies.

cmunnelly

Technical User
Joined
Jul 4, 2003
Messages
16
Location
GB
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

 
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? [ponder]
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244
 
Hi

Enter
=CELL("filename")

in A1

Keith
 
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? [ponder]
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244
 
sorted it. thanks for the help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top