Hyperlinks not behaving

[Jeffrey Smith]

I imported many rows cells containing paths to locations on our server. If I edit the cell manually and do nothing but hit enter, Excel reformats the text as a link that I can click on and open a windows explorer screen at that location. Right now the text does not display as a link.

Without having to manually edit 20,000 cells, is there an easier way. I tried searching for some VBA code to actually edit a cell.

Thanks for any help.

Jeff

 

[mohan.ankur]

Hi Jeff,

Sub HyperLinkActivate()

For i = 1 To 10
Cells(i, 1).Select

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
ActiveCell.Value, TextToDisplay:= _
ActiveCell.Value
Next i
End Sub

i here represents the number of rows that you have in the sheet.

Regards
Ankur K Mohan