Different ways to recalculate a cell or a range in VBA
<p>The first approach is suggested in <a href="https://stackoverflow.com/questions/8342012/is-it-possible-to-recalculate-only-a-cell-or-a-range-in-vba">is it possible to recalculate only a cell or a range in VBA</a> 's  <a href="https://stackoverflow.com/a/8342067/826203">reply</a>:</p>

<pre><code>Range("A1").Calculate
</code></pre>

<p>The second approach is in <a href="https://stackoverflow.com/questions/154434/how-do-you-get-excel-to-refresh-data-on-sheet-from-within-vba">How do you get Excel to refresh data on sheet from within VBA?</a> 's <a href="https://stackoverflow.com/a/18621896/826203">reply</a> :</p>

<pre><code>Cells(RowA,ColB).Formula = Cells(RowA,ColB).Formula
</code></pre>

<p>The third one </p>

<pre><code>Range("XXX").Value = Range("XXX").Value
</code></pre>

<p>seems also work.</p>

<p>Are there any difference among the three?</p>