| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bulk replacement of cell reference within formula | Excel Worksheet Functions | |||
| Copying bulk cells that matches a single cell name | Excel Worksheet Functions | |||
| how do i take off 15% of bulk prices in excel | Excel Discussion (Misc queries) | |||
| BULK Conditional Formatting - by column without going into each cell? | Excel Discussion (Misc queries) | |||
| naming .xls file based on a cell in excel | Excel Discussion (Misc queries) | |||
Linear Mode
