Excel: Cell Naming Bulk Delete
 

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.

Excel: Cell Naming Bulk Delete
 

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

"Grant" wrote:

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.