Remove Hyperlinks
I have the following routine that works
Sub Remove_Link()
With Selection
Selection.Hyperlinks.Delete
End With
End Sub
Otto Moehrbach wrote:
Excel XP, Win XP
I have a list of hundreds of hyperlinked cells scattered throughout more
hundreds of non-hyperlinked cells. I want to remove the hyperlinks. What
is the code query for a hyperlinked cell?
Something like:
If ActiveCell....hyperlink...=True Then
Thanks for your time. Otto
|