Delete defined name

[ehoory]

Hi,
I have a file that contains hundred of names (defined name). Most of these names are linked to other files that are not existing any more.
I need your help to delete all the names.

thanks.

 

[adder70]

Hi,
I have a file that contains hundred of names (defined name). Most of these names are linked to other files that are not existing any more.
I need your help to delete all the names.

thanks.

Ooh! I can answer that!

Open name manager. It's on the Formulas ribbon in 2007, or just open help to see where it is. This will give a dialog box with all the names. You can shift+select to select a whole bunch at once. You should be able to sort by the "refers to" column to align the ones you want to delete.

 

[iggydarsa]

I couldnt find a way to select multiple Names in version 2003 and earlier, so you might want to run this macro to delete all the Names in the workbook

Sub delName()
For Each nm In Names
    ActiveWorkbook.Names(nm.Name).Delete
Next nm
End Sub

 

[ehoory]

I tried to run the macro you send me but I got error 1004.
Do you know what it means?
I use XL 2002.

 

[DonkeyOte]

dupe post

http://www.mrexcel.com/forum/showthread.php?t=326773

I don't know what the issue is in XL2002 -- hopefully someone can address this for you -- i don't run that version myself.

What value do you get in VBA if you type

Sub zz()
x = ActiveWorkbook.Names.Count
End Sub

 

[ehoory]

I ran the macro. Where should I see the value?

 

[iggydarsa]

if you run this:

Sub zz()
x = ActiveWorkbook.Names.Count
MsgBox x 
End Sub

the value should display on a popup window