Excel Named Range Removal

[Scott Palmer]

I have several workbooks that were created with hundreds
of named ranges. I only know how to delete them one by
one by using the Insert->Name->Define... to open the range
list box. Excel will not allow a group selection to
delete more than one. I HAVE THOUSANDS TO DO! Is there
any other way to delete them all???? Please Help!

 

[Anon]

I have several workbooks that were created with hundreds
of named ranges. I only know how to delete them one by
one by using the Insert->Name->Define... to open the range
list box. Excel will not allow a group selection to
delete more than one. I HAVE THOUSANDS TO DO! Is there
any other way to delete them all???? Please Help!

Same question was asked yesterday. Below is a copy of the reply from Norman
Harker:


Simplest way is to use an old Lotus keystroke command that works in
Excel but which doesn't have an equivalent without VBA.

Tools > Options > Transition
Select the Lotus 1-2-3 Help option

Thereafter:

/RNR

Will clear all of your names including those set by Excel such as
Print_Area.

But watch out. There's no, "Are you sure!" And there's no Undo
capability. But if this is what you want, it sure beats doing it one
at a time.

A more user friendly approach is used by Rob Bovey in Excel Utilities
1.5 obtainable from:

Rob Bovey
http://www.appspro.com/

Apart from this clearance of all names there's a lot more other useful
"everyday" utilities included.

 

[jan]

Scott,

Just copy everyting onto a new workbook, the ranges will
be left behind, even if you pastespecial>all

grtz,
J

 

[Dave Peterson]

If you want to keep some and delete others, I'd download Jan Karel Pieterse,
Charles Williams and Matthew Henson's utility called NameManager.Zip from
http://www.bmsltd.co.uk/mvp