title: Range() VS Cells() - run times
body: <p>I see a lot of VBA code on this site using the <code>Range</code> method with <code>For</code> loops:</p>
  
  <pre><code>Range("A" &amp; i)
  </code></pre>
  
  <p>As opposed to a proper <code>Cells</code> command:</p>
  
  <pre><code>Cells(i,1)
  </code></pre>
  
  <p>I always knew the <code>Cells</code> way was faster, partly because <code>Range</code> takes longer to resolve, and partly because concatenation (<code>&amp;</code>) is a relatively slow process (as opposed to any other simple arithmetic operation - AFAIK).</p>
  
  <p>So, the question is, is it <em>really</em> faster? By how much? Sometimes, the <code>Range</code> format is more readable, especially for newbies. Does the speed gain justify the slight discomfort and necessary extra explanation in replies?</p>