I wish to use a hyperlink and have the destination address display automatically at the top left of the screen. I found VBA through another thread that works well for hyperlinks created with the wizard.
However, that VBA does not work if the hyperlink is formula based.Please Login or Register to view this content.
=HYPERLINK("#"&ADDRESS(MATCH(B10,$A$1:$A$15000,0),1), "Link")How do I use the formula and have the destination appear top left on screen?
Bookmarks