Removing hyperlink from multiple cells in Excel

L

L

How can I remove hyperlink from a column all at once? I
have only found a way to do it cell by cell.
 
K

Ken Wright

Slight Tweak on previous post of Dave's for removing screen tips. Select the column and run the
routine.

Sub RemoveHyperlinks()
'David McRitchie, misc, 2003-04-08, misc
Dim Cell As Range
For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
On Error Resume Next
Cell.Hyperlinks.Delete
Next Cell
End Sub
 
Top