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

Thanks, Stefano

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

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

Thanks, Stefano

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.

smaruzzi wrote:

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

Thanks, Stefano

--

Dave Peterson