View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] acampbell012@yahoo.com is offline
external usenet poster
 
Posts: 129
Default 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