title: How to enter a formula into a cell using VBA?
body: <p>I am trying to enter a formula into a cell which contains variable called var1a?
  The code that I have is:</p>
  
  <pre><code>    Worksheets("EmployeeCosts").Range("B" &amp; var1a).Formula = ""SUM(H5:H""&amp; var1a)
  </code></pre>
  
  <p>But it enters into an excel worksheet with a mistake.</p>