Deleting Broken Defined Name

I have large model that over the years accumulated a lot of name ranges, to the point that the name manager will not open.

Most of the solutions that I found so far are not working to get the numbers of defined names down. I was hoping to run this code; however, I run into a memory error:

Please Login or Register  to view this content.

I also don't fully know which name ranges are needed versus not (or least by defined name) so a total delete of the list or a specific, delete anything that contains x,y,z would be difficult so ideally would want to stick with the delete any errors and hope name manager opens by then. None the less open to other suggestions.

Thanks

I've been using the following code to get the the number of defined name ranged down to a manageable list (e.g., being able to open name range manager):

Please Login or Register  to view this content.

In a recent hand me down file with a significant amount of stalled name ranged, I get an "out of memory" (7) error. Any recommendations on code alterations to make it run?

Thanks