name deletion
 

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

name deletion
 

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.

rk0909 wrote:

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

name deletion
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"rk0909" wrote in message
...
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