Removal of broken Hyperlinks from data copiedfrom a web page in to an Excel Spreadsheet

[Guest]

I have copied over 600 + lines into excel from a web page data base. I have cells which appear as hyperlinks (blue underlined text). When I put the insertion point over the cell, I get the little "hand" and a hyperlink box opens but is blank. I do not want the text in the cells to be hyperlinks nor do I want to open any hyperlinks. I went to the edit menu to select links to remove all but links is grayed out. I can remove each one, one by one, by using the arrow key to move into the cell, doing a right click and select, remove hyperlink. This works, but will not accept multiple cells at a time. It is very time consuming to remove 600+ links one at a time....I need a select all delete hyperlink approach...any suggestions.

 

[Don Guillett]

try this
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)

I have copied over 600 + lines into excel from a web page data base. I

have cells which appear as hyperlinks (blue underlined text). When I put
the insertion point over the cell, I get the little "hand" and a hyperlink
box opens but is blank. I do not want the text in the cells to be
hyperlinks nor do I want to open any hyperlinks. I went to the edit menu to
select links to remove all but links is grayed out. I can remove each one,
one by one, by using the arrow key to move into the cell, doing a right
click and select, remove hyperlink. This works, but will not accept
multiple cells at a time. It is very time consuming to remove 600+ links
one at a time....I need a select all delete hyperlink approach...any
suggestions.