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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by TTnewbie
-
Excel Hyperlink subaddress can't be forced to string type
Thanks a lot Rob, it solves my problems.- TTnewbie
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel Hyperlink subaddress can't be forced to string type
I'm trying to have a macro read all the sheet names in a workbook and produce a Table of Contents (TOC) in which the sheet names are also hyperlinks to the sheet. I ran into a problem with a notebook in which sheet names were 13E1, 22E2, etc. because the hyperlink subaddress gets interpreted as...- TTnewbie
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
