Converting Text to Clickable Links

I have a spreadsheet ful of text URLs which are not clickable. How does one convert a link to a clickable link which will open a browser and go to the associated URL?

I figured that this would be easy to figure out!



Thanks for any and all feedback.

L

This macro will do it:


Sub HyperAdd()
'
' Converts each text hyperlink selected into a working hyperlink
'
For Each xCell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
Next xCell
'
'
End Sub

Thanks Legs! It works like a charm!!

Originally Posted by Legs

This macro will do it:


Sub HyperAdd()
'
' Converts each text hyperlink selected into a working hyperlink
'
For Each xCell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
Next xCell
'
'
End Sub