Hyperlinks not behaving

Jeffrey Smith

Well-known Member
Joined
Feb 11, 2005
Messages
795
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
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

mohan.ankur

New Member
Joined
Aug 19, 2005
Messages
1
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,328
Messages
5,571,564
Members
412,405
Latest member
DutchMonkey
Top