Out of Memory when trying to delete named ranges

[Groovicles]

Hi,

I have a workbook that contains likely thousands of old named ranges that are not used anymore. There are so many named ranges that I can't even open the Name Manager. The named ranges I'm trying to delete have a similar syntax. The following is the code I've written for it:

Please Login or Register  to view this content.

I believe this code should work, however whenever I try to run it I get the Out of Memory Error 7 error.

Any one have any ideas how I can adjust this code to remove these similar named ranging without running out of memory?

Thanks!!

[romperstomper]

That is not a valid name, so I don't see the point of the code? Did you mean to use 'Like' rather than '='?

[Groovicles]

Hi Rorya,

Yes, I tried using a wildcard rather than using Like. Any suggestions to get around the memory issue?

[romperstomper]

Do you get the same issue with this code:

Please Login or Register  to view this content.

[Groovicles]

Hi Rorya. Yes, I get the same out of memory error 7 message.

[romperstomper]

You may be SOL with VBA then. Does this work:

Please Login or Register  to view this content.

[Groovicles]

Hi Rorya,

Thanks for the code. I tried and ran it. I didn't get the error message but it doesn't appear that anything happened. None of the named ranges were removed.

[romperstomper]

It occurs to me that a name cannot begin with anything other than an underscore or a letter, so what do the actual names look like - can you give a specific example?

[Groovicles]

Yes you're correct. The names all begin as Y.00 and then 6 numbers behind that.

[romperstomper]

Then try:

Please Login or Register  to view this content.

[Groovicles]

Thanks. I actually tried that already. No errors this time, but it doesn't appear that anything happened either.

[romperstomper]

Did you have the correct workbook active when you ran it? If so, I suspect you may have to edit the XML of the file (assuming it's an XML based format rather than binary).

[Groovicles]

Yes, the macro is being run in the same workbook that has the named ranges. What do you mean edit the XML of the file? I'm not familiar with that.

[SjonR]

try this:

Please Login or Register  to view this content.

[romperstomper]

I mean you'd have to unzip the workbook (it's basically a compressed folder) and then edit the XML to remove the name definitions.