Web addresses

[WWII]

I am entering a series of web addresses in a column. How do I format them
so I can just click on them and go to Internet Explorer?

Thanks.

W Weldin

 

[Don Guillett]

try this. Adjust range [c1:c18] to suit

Sub MakeHyperlinks()
For Each c In [C1:C18] 'Selection
With ActiveSheet
.Hyperlinks.Add Anchor:=c, _
Address:="http://www." & c.Value & ".com/"
End With
Next c
End Sub