name deletion

  • Thread starter Thread starter rk0909
  • Start date Start date
R

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
 
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.
 
Sub DeleteAllNames()
For Each N In sheet("sheetname").Names
N.Delete
Next N
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does this code not work? 12
Need help deleting data 2
Chart Name 4
Help with rest of forumla - Delete rows based on criteria 4
Dual boot 3
Deleting Multiple Blank Rows 6
Deleting Multiple Names 6
Macro to delete Column 1

Back
Top