Range() VS Cells() - run times
<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>