Dave Peterson is a very smart person!!!!!

I love you Dave!!!!

Thank you for taking the time to write this because you saved me from
manually going in to 1,843 cells and removing hyperlinks.

:)

"Dave Peterson" wrote:

Select all the cells (ctrl-A (twice in xl2003))
hit alt-f11 (to get to the VBE, where macros live)
hit ctrl-g (to see the immediate window)

type this and hit enter:

selection.hyperlinks.delete

Close the VBE and back to excel to see if it worked.

===
You could even just select a smaller range and just clean that since the command
uses the current selection.

davey wrote:

--

Dave Peterson