I am trying to modify an existing hyperlink from a VBA macro
The existing link is in cell B1 (B1 through H1 are merged to fomB1 if that makes a difference) of worksheet("TestSheet")
I want to change the existing subaddress from whatever it is to "UI!A", and the TextToDisplay from whatever it...