Thanks for the advice.
I managed to discover the use of #. It was hidden in Excel Help on the Hyperlink worksheet function.
However, to open the whole page I had to first highlight the whole rows/columns used on the page and set it up as Named Range.
It then opened when called by the...
I am using Word to generate Web Pages that collect together links to several Excel models .. but I want each individual Hyperlink to point to a specific Worksheet within a given Workbook..
Is this possible and, if so, what is the syntax? I have tried combinations of comma, space and exclamation...
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.