title: Loop through all named ranges in a Excel Sheet
body: <p>I need to loop through all named ranges in my sheet.<br>
  I am currently doing this:</p>
  
  <pre><code>For Each nm In ActiveWorkbook.Names
  </code></pre>
  
  <p>The problem is that this sheet has names with global scope and with sheet scope.<br>
  This loop only gets the global scope.<br>
  I've tried:</p>
  
  <pre><code>For Each nm In Activeworkbook.Sheets(1).Names
  </code></pre>
  
  <p>But couldn't make it work. This loop also only gets those named ranges with global scope. Ideas?<br>
  I know the best solution would be to change the scope of the name, but I can't do it.</p>