Removing Hyperlinks

[john.bedford3]

I am sure I have seen this question before on this newsgroup but can not
seem to find the thread.

Is it possible to remove hyperlinks in bulk from a worksheet or must they be
done one at a time?

 

[Jim Cone]

John,

You can copy a blank cell and then Paste Special | Add to your selected cells.
However, this does add a zero to formulas...
= A1 + B1 becomes... = A1 + B1 + 0

Regards,
Jim Cone
San Francisco, USA

 

[Gord Dibben]

John

See David McRitchie's site for various methods of deleting hyperlinks,
including worksheet function and VBA methods.

http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks


Gord Dibben Excel MVP

 

[Anne Troy]

Here's another macro, with instructions for its use:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=73

*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com

 

[john.bedford3]

Many thanks to Jim, Gord and Anne for their replies.