Hyperlinking many text links via Macro

Hi Guys,

I have got around 500 links that needs to be hyperlinked. Also I need to change the Text to Display field to Mol View everytime I hyperlink. I have got the code for two links. I want that to be done for rest of the cells as well. But the links are different in each cell.

Here is the code->

Please Login or Register  to view this content.

Thanks in advance.

Cheers
plasma33

where will the macro get the information about the addresses of the other hyperlinks?

Thanks for your reply. Its all in the cells between I2 to I500.

Cheers
plasma33

Hi
if the locations of the hyperlinks are typed in cells I2:I500, and you want to insert the hyperlinks in the same cells, try this:

Please Login or Register  to view this content.

Worked perfectly. Thanks a ton.

Cheers
plasma33