Modifying a Hyperlink SubAddress

[dbodimer]

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 is to "RETURN to UI"

I've tried several things found on the web, but am not having any luck.

 

[dbodimer]

Got it fixed. The problem was in the selection. THANK YOU!