steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
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 )-:
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?
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 )-:
Code:
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?