Opening a hyperlink in a cell with a macro

[steve case]

My formula in cell A1 says: =HYPERLINK(A2,A3)
Cell A2 has the URL
Cell A3 has the name of the website.

And it works, if I click on cell A1 it opens the internet and my target website appears (-:

But my test macro to do that doesn't )-:

Sub SelectHyperlinkCell()
'
' SelectHyperlinkCell Macro
'


'
    Range("A1").Select
End Sub

I have URLs all the way down
A1
A2
A3
...
A1500

So I would like to have macro that as the last instruction opens up the link. Can this be done?

 

[Macropod]

This thread is duplicated by: https://www.mrexcel.com/forum/excel-questions/1093185-can-i-tell-macro-open-hyperlink.html
Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.