title: VBA to use sum formula for cells in same row. Row number will change with each loop
body: <p>I'm using VBA to extract numbers from a website using a loop. I have these numbers imported into column F and G. I'm trying to include a line in my VBA that would allow me to use the sum formula to add these two cells and post the result in column E.
  The numbers will always be in the same row, but in columns F and G.</p>
  
  <p>Can i use the (ActiveCell.Row) function in this way?
  or should just use an If function at the end of my loop.</p>
  
  <pre><code>Range("E" &amp; (ActiveCell.Row)).Formula = "=SUM("Range("F" &amp; (ActiveCell.Row)) &amp; Range("G" &amp; (ActiveCell.Row))")"
  </code></pre>