title: VBA Remove 100k + named ranges
body: <p>So basically I've gotten a legacy excel from my predecessor to process a bunch of data. 
  He basically names each datapoint and process them accordingly. 
  The problem is that his codes does not clear away the old used names, resulting in names accumulating through the years. 
  Right now I've got 100k + names in my excel sheet that I can't clear. </p>
  
  <p>I've tried using:</p>
  
  <pre><code>Sub dlname 
  
    Dim nm as name 
  
    For each nm in activeworkbook.names
  
      nm.delete
  
    Next nm 
  
  End sub 
  </code></pre>
  
  <p>It'll always give me runtime error 7, out of memory. </p>
  
  <p>Any solutions to this ?</p>