Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete a hundred range names at once?
Hello!
How to select many names in the "Define Name" window in Excel 2003 sp3 to delete them? I unintentionally copied a thousand range names into a workbook when copied a sheet from another workbook. or, How to delete a hundred range names at once? Regards, Dmitry |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete a hundred range names at once?
Hi,
Right click any sheet tab, view code and paste this in and run it. Note it will delete all names in your workbook. Sub delnames() Dim nm As Name On Error Resume Next For Each nm In ActiveWorkbook.Names nm.Delete Next On Error GoTo 0 End Sub Mike "Dima" wrote: Hello! How to select many names in the "Define Name" window in Excel 2003 sp3 to delete them? I unintentionally copied a thousand range names into a workbook when copied a sheet from another workbook. or, How to delete a hundred range names at once? Regards, Dmitry |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete a hundred range names at once?
Get hold of Namemanager, a free utility, from
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- __________________________________ HTH Bob "Dima" wrote in message ... Hello! How to select many names in the "Define Name" window in Excel 2003 sp3 to delete them? I unintentionally copied a thousand range names into a workbook when copied a sheet from another workbook. or, How to delete a hundred range names at once? Regards, Dmitry |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete a hundred range names at once?
Thanks Mike for your macro!
I have found the Name manager Add-in. "Mike H" wrote: Hi, Right click any sheet tab, view code and paste this in and run it. Note it will delete all names in your workbook. Sub delnames() Dim nm As Name On Error Resume Next For Each nm In ActiveWorkbook.Names nm.Delete Next On Error GoTo 0 End Sub Mike "Dima" wrote: Hello! How to select many names in the "Define Name" window in Excel 2003 sp3 to delete them? I unintentionally copied a thousand range names into a workbook when copied a sheet from another workbook. or, How to delete a hundred range names at once? Regards, Dmitry |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete a hundred range names at once?
Thanks Bob!
"Bob Phillips" wrote: Get hold of Namemanager, a free utility, from http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- __________________________________ HTH Bob "Dima" wrote in message ... Hello! How to select many names in the "Define Name" window in Excel 2003 sp3 to delete them? I unintentionally copied a thousand range names into a workbook when copied a sheet from another workbook. or, How to delete a hundred range names at once? Regards, Dmitry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete a hundred range names at once? | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
not delete worksheets from names in a range | Excel Discussion (Misc queries) |