Excel follow Hyperlink not working

[brobert95]

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