Follow Hyperlink with Macro

[Nidivre]

Hi again!

I was wondering if anyone could please help me with this, I've been trying to make a macro that will follow my hyperlink (on the same sheet) but all the stuff on the Internet doesn't work. The best one I have tried is

Please Login or Register  to view this content.

But with this I get the error "Subscript out of range".

Does anyone know how I can fix this?

Thanks a lot!

[pike]

Hi Nidivre
HWelcome to the forum,
Try the cell where twith the link....

Please Login or Register  to view this content.

[Nidivre]

Hi Nidivre
HWelcome to the forum,
Try the cell where twith the link....

Please Login or Register  to view this content.

Thanks for the welcome, pike, unfortunately I get the same error
This is what I have:

Please Login or Register  to view this content.

[pike]

Hi Nidivre
whats the link?
you could remake the link to check it

Please Login or Register  to view this content.

[Nidivre]

Hi Nidivre
whats the link?
you could remake the link to check it

Please Login or Register  to view this content.

Hmm that doesn't seem to work at all, the reason I was going to press a macro to go to the hyperlink was because I have to use a link hyperlink so the picture doesn't support the extended link:

Please Login or Register  to view this content.

It's supposed to search that site for whatever is in A7.

[pike]

try this

Please Login or Register  to view this content.

[Nidivre]

try this

Please Login or Register  to view this content.

That gives me a syntax error - I'm a huge noob with this and I really appreciate your patience, thanks again for the help - hopefully we can find a way to get it working!

[pike]

hi Nidivre
what is the web address?

[Nidivre]

hi Nidivre
what is the web address?

The website address is "http://ffxiv.yg.com/search?s=SEARCHHERE" with "SEARCHHERE" being whatever is in A7.

EDIT: This has been solved, the code that made it work was:

Please Login or Register  to view this content.

Thanks for your help!

[pike]

hi Nidivre
Try this in the worksheet module
type the search word into a7 and double click it

Please Login or Register  to view this content.