I have the following code that I need to follow a hyperlink. The problem is G7 is using a formula to get the hyperlink from Vlookup. If I manually type the hyperlink into G7, the below code works, but with the formula in G7 it will not. Thanks in advance for any help.
Sub FollowHyperlink()
ActiveSheet.Range("g7").Hyperlinks(1).Follow
End Sub
Sub FollowHyperlink()
ActiveSheet.Range("g7").Hyperlinks(1).Follow
End Sub