Removing hyperlink from multiple cells in Excel

  • Thread starter Thread starter L
  • Start date Start date
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.
 
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
 
Back
Top