name deletion

[rk0909]

Hi all,
I want to delete lot of names from a sheet. is there an easy way via a macro
to delete the names rather than going and deleting them manually.

Thanks much,

RK

 

[Dave Peterson]

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 working with names much easier.

 

[Don Guillett]

Sub DeleteAllNames()
For Each N In sheet("sheetname").Names
N.Delete
Next N
End Sub