VBA to Open Dynamic URL Hyperlink

[gmooney]

Hi,

I have posted a couple of requests on some forums with great suggestions, but nothing has quite worked.

My scenario:

I have a couple combo box dropdowns that will update a cell A1 (Range Name of URL) with a HYPERLINK formula (=HYPERLINK(XLOOKUP(A2,'Report Links'!$AJ:$AJ,'Report Links'!$AD:$AD),"URLSTORY") returning a hyperlink from the "Report Links" sheet. The cell A1 is in Sheet1.

My current Macro (on a Button on "Report Links" sheet:

Sub Macro1()
Application.ScreenUpdating = False
Worksheets("Sheet1").Activate
Range("URL").Hyperlink.Follow
Application.ScreenUpdating = True
End Sub


This gives me an error of Runtime error 438, "Object Doesn't Support this property or method." on the Range("URL").Hyperlink.Follow line.

Any ideas how I can overcome this?

 

[Marc L]

Hi,​

​

as a 'hyperlink formula' is nothing else but a formula so very not a hyperlink object​

as you can check out within your code with the Count property of the Hyperlinks collection …​

​