title: Different ways to recalculate a cell or a range in VBA
body: <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>