You can do this with the urls in column B
Sub test()
For Each myCell In Columns("B").Cells.SpecialCells(xlCellTypeConstant s)
If myCell.Value Like "http://www.*" Then
ActiveSheet.Hyperlinks.Add Anchor:=myCell, _
Address:=myCell.Value, TextToDisplay:=myCell.Value
End If
Next
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"M_E_Luft" wrote in message ...
I have an excell file with 2500 urls in it that were saved as plain text...i
need to hyperlink all of them but i don't want to do it 2500 times....does
anyone know a way to mass hyperlink several lines