Excel Sheet Tab Names 2

[Scott24x7]

All,
Is there a way (via formula) to get the name from a sheet tab for use as a cell in another page? (Something like referencing a cell, with ='Sheet1'!A5) but to get the name off the sheet tab itself?

Many thanks and


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[Scott24x7]

Appreciate all the help everyone... but I've abandoned the idea of having a single dynamic cell that captures the name of a sheet, and serves as the hyperlink dynamically. I have read and re-read about a dozen times the help file on this, used your examples, and I still can't get this to work. If I have to set they hyperlinks manually, I guess that's what I'll have to do.

Incidentally, I could not even get the =HYPERLINK() function to work at all, to actually take me to a specified cell on a nother page, which I found really disappointing. I even copied the example out of help, set up the same pages, and it didn't work. So, I'll stick with what I've got for now...


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[firefytr]

How about a table of contents...

http://vbaexpress.com/kb/getarticle.php?kb_id=120

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci