Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I use the following macro to remove all the range names in a workbook:
Sub RemoveNamesAll() For Each N In ActiveWorkbook.Names N.Delete Next N End Sub As indicated it removes ALL names. However I would like to change thi so that it removes all, except for "Print_Area" and "Print_Titiles". have tried to modify the macro so that those two are not removed without success. Does anybody have any ideas -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing labels and names in formulas | Excel Discussion (Misc queries) | |||
Finding/removing duplicate names in a worksheet | Excel Worksheet Functions | |||
Removing range names. | Excel Discussion (Misc queries) | |||
removing and inserting duplicate names | New Users to Excel | |||
Removing Duplcate Names | Excel Worksheet Functions |