Excel Launch Hyperlink VBA

[Robertson1995]

Hello. I need VBA code to launch the hyperlink in Cell C11. Thanks in advance for any help.

Cell C10 contains a vlookup formula that pulls data from another sheet
Cell C11 contains the formula =Hyperlink(C10)

I've tried the code below, but it is not working. I can click on the link in C11 and it works, but the VBA won't work.

Sub FollowLink ()

Range("C11").Hyperlinks(1).Follow

End Sub

 

[rowebca]

You can use:

ActiveWorkbook.FollowHyperlink Range("c11")

Regards,
GB

 

[Robertson1995]

That worked great. Thanks very much for your help.