Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass deletion of block names
I manage a large, complex spreadsheet that tracks statistical information for
several of our operations centers. It's been in existence since the mid 90's and as our company structure has evolved so has the spreadsheet. My problem is that there are now roughly 2000 named blocks in the spreadsheet, although many reference areas of the spreadsheet no longer used. Is there a way to delete several hundred defined block names in a single stroke. I'm relatively fluent in VBA so there's a coding solution I'm open to it. Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass deletion of block names
Download Name Manager from
http://www.decisionModels.com/Downloads.htm Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "danhattan" wrote in message ... I manage a large, complex spreadsheet that tracks statistical information for several of our operations centers. It's been in existence since the mid 90's and as our company structure has evolved so has the spreadsheet. My problem is that there are now roughly 2000 named blocks in the spreadsheet, although many reference areas of the spreadsheet no longer used. Is there a way to delete several hundred defined block names in a single stroke. I'm relatively fluent in VBA so there's a coding solution I'm open to it. Thanks in advance for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass deletion of block names
To just delete the bad ones try this. For ALL use n.delete (be CAREFUL what
you ask for) Sub donames() For Each n In Names If InStr(n, "#REF") 0 Then n.Delete 'MsgBox n Next End Sub -- Don Guillett SalesAid Software "danhattan" wrote in message ... I manage a large, complex spreadsheet that tracks statistical information for several of our operations centers. It's been in existence since the mid 90's and as our company structure has evolved so has the spreadsheet. My problem is that there are now roughly 2000 named blocks in the spreadsheet, although many reference areas of the spreadsheet no longer used. Is there a way to delete several hundred defined block names in a single stroke. I'm relatively fluent in VBA so there's a coding solution I'm open to it. Thanks in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Replace range names with cell references? | Excel Worksheet Functions | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |