Excel Vba Hyperlink help

[wahmed]

Hi,

Can anyone help me to understand this Excel vba follow hyperlink method ?


Range("A1").Hyperlinks(1).Follow

My Question is why we need to Write .hyperlinks(1).follow what does (1) stand for in this method, can we not just use .hyperlinkes.follow ?

Waiting for your help in detail to understand it easily.

regards

Wahmed

 

[daverunt]

The 1 is the index number. Each hyperlink will have it's own.
I have not used this code before but I presume from this that the deafult of 1 is used at minimum

http://msdn.microsoft.com/en-us/library/aa244606(v=office.10).aspx

 

[daverunt]

posted twice - removed

 

[wahmed]

Dear Davernut,

Thanks for your reply to my question.

Sorry but still it is not cleared if we have 100 hyperlinks in a worksheet then we use Hyperlinks(1).follow for all of them, so what does index stand for ? can we use Hyperlinks(2) or (3) as well ??

Please explain.

Regards

Wahmed

 

[daverunt]

If you are selecting only one cell or a range with 1 cell on your worksheet then you would use:

   ActiveSheet.Range("G10").Select
   Selection.Hyperlinks(1).Follow

If you are selecting a range that contains several hyperlinks in it
you would have to specify which link you wanted to follow.

   ActiveSheet.Range("G10:G15").Select
   Selection.Hyperlinks(x).Follow
 
where x = one of a number of hyperlinks in that range.

 

[RSXchin]

THAT'S what the number is for? You learn something new every day...

so if i do this...

ActiveSheet.Range("G1:G5").Select
Selection.Hyperlinks(5).Follow

does it activate ALL of the links, or just number 5 (g5)?

 

[daverunt]

Yes I just learned the very same 20 minutes ago : )

It would follow the link in G5 assuming each cell has a hyperlink.

If there are less than 5 links in that range then - 'Subscript out of range'.

 

[wahmed]

Dear Davernut,

thanks for explaining.

but excel is assuming .hyperlinks(5).follow with 5th sheet of a workbook whether name of sheet has changed....

Please recheck and then reconfirm.

regards

Wahmed

 

[daverunt]

Please post the code you are using and an explanation of what you are seeing so I can understand.