Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Named Ranges
Is there a way to delete all named ranges in a workbook ?
Regards and thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Named Ranges
Here's a little snippet of VBA to do that:
For Each nme In ActiveWorkbook.Names nme.Delete Next nme I can't remember who posted it originally, but I find it very useful. Hope this helps Pete carl wrote: Is there a way to delete all named ranges in a workbook ? Regards and thank you in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Named Ranges
Download and install Name Manager (link below). It is a great tool for
managing all of your named ranges. In Excel 2007 a similar tool is included as default, until then gotta do this extra little step: http://www.jkp-ads.com/officemarketplacenm-en.asp -- Regards, Dave "carl" wrote: Is there a way to delete all named ranges in a workbook ? Regards and thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Deleting many named ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |