making normal text to hyperlink.
 

Hi all,

I have the following issue,

I load a bunch of web adresses from a text file into excel.
Example:

www.microsoft.com
www.playboy.com
etc.
etc.


When I do this the web adresse are displayed as text.
How do I get them to perform/display as a hyperlink so clickin on the
text will bring me directly to the site?
The data to load is different every time.

Looking forward to see any options to my problem.

Ronald

making normal text to hyperlink.
 

select them then run this
Sub AddHperLinks()
Dim cl As Range

For Each cl In Selection.Cells
ActiveSheet.HYperLinks.Add Anchor:=cl, Address:=CStr("http://" & cl.Value)
Next cl
End Sub

cheers
Simon

"Ronald" wrote:

Hi all,

I have the following issue,

I load a bunch of web adresses from a text file into excel.
Example:

www.microsoft.com
www.playboy.com
etc.
etc.


When I do this the web adresse are displayed as text.
How do I get them to perform/display as a hyperlink so clickin on the
text will bring me directly to the site?
The data to load is different every time.

Looking forward to see any options to my problem.

Ronald