title: Insert function is giving 1004 error in excel macro vba
body: <p>Below code is giving error (1004)</p>
  
  <pre><code> Sheets(2).Cells(i, 7).Formula = "=LEFT(" &amp; Sheets(2).Cells(i, 5) &amp; ",2)"
  </code></pre>