title: What is the most efficient/quickest way to loop through rows in VBA (excel)?
body: <p>I know VBA in Excel isn't the quickest of things - but I need the most efficient (i.e. quickest) way to loop through a large sample of rows.</p>
  
  <p>Currently I have:</p>
  
  <pre><code>For Each c In Range("$A$2:$A$" &amp; Cells(Rows.count, "A").End(xlUp).row
      ' do stuff
  Next c
  </code></pre>
  
  <p>The 'do stuff' includes insert a row here and there (so I need to keep the dynamic lookup of the range.) </p>
  
  <p>Any ideas (looking at 10,000 rows+)?</p>
  
  <p>EDIT
  I am already using </p>
  
  <pre><code>Application.ScreenUpdating = False
  Application.Calculation = xlManual
  </code></pre>