Deleting name all at once

[Guest]

Is there a way to delete all defined names with a single action?

Thanks, Stefano

 

[Pete_UK]

Here's a simple macro to do it:

Sub remove_names()
'delete named ranges
For Each nme In ActiveWorkbook.Names
nme.Delete
Next nme
End Sub

Hope this helps.

Pete

 

[Dave Peterson]

There are names that excel creates and uses (and are usually hidden).

You may not want to remove all the defined names.

Get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll make deleting names easier and safer.