Macro to convert string to hyperlink

Hi everyone,

I have the following code:

Please Login or Register  to view this content.

This code is supposed to go through column K and convert any test strings within each cell starting with http:// or www. from a string to hyperlink. It is possible that other text will be in the cell which should not be converted to a hyperlink; on text that starts with http:// or www.

When I run the code I get run-time error 13 and the if InStr line is indicated. Any ideas?

Thanks!

hi Ron,

Thanks for the reply and your code. Unfortunately your code converts the entire text in the cell to a hyperlink. What I'm trying to do is work out a macro that will convert only text in the cell starting with http:// or www. into a hyperlink and leave the other text as text. Any ideas?

Thanks,