Adding http:// in front of a column of IP addresses in excel

[Pandab2002]

I have a column of 233 IP addresses. I'd like to be able to just click on any of the addresses to reach the web application associated with that IP address. I have tried using concatenate the IP address with a column that contains http:// but it does not create a link. If I manually type

http://10.10.10.199

excel automatically sets it as a link. I'm sure the answer is staring me in the face, but I can't figure it out.

 

[Loomah]

Hi
How about somethng like this

Dim c As Range
For Each c In Range("A1:A233")
    ActiveSheet.Hyperlinks.Add Anchor:=c, Address:="[URL unfurl="true"]http://"[/URL] & c
Next

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Pandab2002]

Thank you so much. Worked like a charm.