wrong Hyperlink-Values

[Rainer Bielefeld]

Hi all,

I have a very strange effect with some Hyperlinks.

I've created a list of my DVDs and lets say in column B I'm saving hyperlinks to IMDB.
I'm opening this Hyperlinks in a macro (FollowHyperlink) but sometimes Excel opens the wrong site.

I've debugged the code and found out that Excel gives me a wrong Address for this hyperlink:

Sheets("Movies").Cells(1, 2).Hyperlinks(1).Address has a wrong value.

But if I move the mouse over Cell(1,2) the tooltip shows the correct address and then, if I run the macro again (without changing
something!!! I've just moved the mouse over the cell!!!), everything goes fine and Excel opens the correct site.

Any ideas?

Kind regards,

Rainer

 

[CurlyDave]

Hi all,

I have a very strange effect with some Hyperlinks.

I've created a list of my DVDs and lets say in column B I'm saving hyperlinks to IMDB.
I'm opening this Hyperlinks in a macro (FollowHyperlink) but sometimes Excel opens the wrong site.

I've debugged the code and found out that Excel gives me a wrong Address for this hyperlink:

Sheets("Movies").Cells(1, 2).Hyperlinks(1).Address has a wrong value.

But if I move the mouse over Cell(1,2) the tooltip shows the correct address and then, if I run the macro again (without changing
something!!! I've just moved the mouse over the cell!!!), everything goesfine and Excel opens the correct site.

Any ideas?

Kind regards,

  Rainer

If you change the Name in B1, the HyperLink code would have to run
again to get the correct address.