How to work with hyperlink index

[GIS2013]

Hi. In each cell in column A ("A1:A50") there is a hyperlink. The macro below will open these hyperlinks simultaneously. I want the macro to open only 5 hyperlinks at a time, how would you do it?

Please Login or Register  to view this content.

[abousetta]

Hi,

You're missing the [/Code] at the end of your code.

If you want to do it pairs of fives, you need a counter.

Please Login or Register  to view this content.

abousetta

[GIS2013]

Hi abousetta, thanks for the solution. I'm getting 'run time error 1004'. The line below is being marked:

Please Login or Register  to view this content.

[abousetta]

Here's an updated code:

Please Login or Register  to view this content.

abousetta

[GIS2013]

First of all thank you it works, but stuck with the second hyperlink. So maybe it'd be better to try completely different plan the would open 50 hyperlinks one by one (or five at a time) but not simultaneously.

[abousetta]

Why is it stuck? Is the URL not working?

You have a few options. 1) check all URLs before running the code. 2) Using IE to open new windows with each URL. There are lots of threads on how to do both.

[GIS2013]

Sorry for delay in response. Cheers abousetta, I'll check both issues.