| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete all names ranges in a workbook after freezing form
Can anyone tell me how to delete all existing name ranges in an excel
workbook after freezing all values |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete all names ranges in a workbook after freezing form
I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp You may not want to delete all the names--sometimes excel creates names for its own use. Wins07 wrote: Can anyone tell me how to delete all existing name ranges in an excel workbook after freezing all values -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete all names ranges in a workbook after freezing
Thank u very much, just what i was looking for.
Cheers "Dave Peterson" wrote: I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp You may not want to delete all the names--sometimes excel creates names for its own use. Wins07 wrote: Can anyone tell me how to delete all existing name ranges in an excel workbook after freezing all values -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete all names ranges in a workbook after freezing form
Sub DeleteAllNames()
For Each Name In Names Name.Delete Next Name End Sub Sub DeleteAllNames_Umlas() ExecuteExcel4Macro "SUM(DELETE.NAME(NAMES()))" End Sub -- Don Guillett SalesAid Software "Wins07" wrote in message ... Can anyone tell me how to delete all existing name ranges in an excel workbook after freezing all values |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to delete all named ranges in a workbook en masse? | Excel Discussion (Misc queries) | |||
| Delete cell names on complete workbook | Excel Discussion (Misc queries) | |||
| How to delete all defined names from a workbook? | Excel Worksheet Functions | |||
| How to delete all defined names from a workbook? | Links and Linking in Excel | |||
| Delete Define names across workbook | Excel Worksheet Functions | |||
Hybrid Mode
