steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
I have a hyperlink in Cell A4 [ =HYPERLINK(B4,E4) ] I can click on it and it opens the webpage just fine.
I would like to have a macro open the web page but I am having no luck trying to figure out from Microsoft Visual Basic Help how to do that.
It's interesting, hyperlinks copied directly in from the web like the one I have in Cell J4 opens with a macro I recorded just as nicely as you please:
But change that to:
in order to open my formula generated link, and it crashes.
So I need help
I would like to have a macro open the web page but I am having no luck trying to figure out from Microsoft Visual Basic Help how to do that.
It's interesting, hyperlinks copied directly in from the web like the one I have in Cell J4 opens with a macro I recorded just as nicely as you please:
Code:
Range("J4").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Code:
Range("A4").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=False
So I need help