Excel: Cell Naming Bulk Delete

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

Excel 2003: Under Insert --> Name. Often times I have excel files with
several hundered named cells or named ranges. I would like to bulk delete
them, instead of, under the "define" screen, using arrow + Alt D, repeatedly.
Thank you for your help.
 
Hi,

Right click any sheet tab, view code and paste this in and run it

Sub standard()
Dim wname As Name
For Each wname In ActiveWorkbook.Names
wname.Delete
Next
End Sub

Mike
 

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

naming cells using insert > name> define 2
How to program excel to insert / delete any worksheet? 1
How to delete a hundred range names at once? 4
Where is "Insert Name" on the menu bar? 6
Formatted cell column in drop down list 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
identifying cells representing certain value and assigning name to 2
Names of workbook cell ranges not accepted with some signs 1

Back
Top