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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.