Web addresses

  • Thread starter Thread starter WWII
  • Start date Start date
W

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
 
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
 
Back
Top