title: Write formulas to Excel cell using VBA variables instead of a long string representing the formula?
body: <p>I typically write formulas from VBA to Excel cells using the following method:</p>
  
  <pre><code>wksActual.Range("D48:D52").Formula = "=SUMIF('6. Calculation sheet'!A:A,C48,'6. Calculation sheet'!J:J)"
  </code></pre>
  
  <p>Is there an alternative way to similarly write a formula to a range of cells but to use more VBA variables and fewer strings?</p>
  
  <p>Something like</p>
  
  <pre><code>wksActual.Range("D48:D52").Formula = Application.Worksheetfunction.Sumif(wksActual.Range("A:A"), wksActual.Range("C48"), wksActual.Range("J:J"))
  </code></pre>