I cut and pasted some information off of the internet onto a spreadsheet.
How can I remove all of the hyperlinks contained in the spreadsheet quickly?
I know how to do it individually, but there has to be a way to speed it up.

I use the macro found in
http://sniptools.com/tipstricks/dele...ffice-document

"Sloth" wrote:

I cut and pasted some information off of the internet onto a spreadsheet.
How can I remove all of the hyperlinks contained in the spreadsheet quickly?
I know how to do it individually, but there has to be a way to speed it up.

Simplest way is to run this macro:

Sub removeHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

If you prefer a non-macro method, try this:

http://exceltips.vitalnews.com/Pages...t_a_Macro.html


"Sloth" wrote in message
...
I cut and pasted some information off of the internet onto a spreadsheet.
How can I remove all of the hyperlinks contained in the spreadsheet
quickly?
I know how to do it individually, but there has to be a way to speed it
up.