title: VBA code to add cell programatically
body: <p>Hi and Thank as well as sorry for asking such a newbie question
  How do I create a VBA code for adding A1 + B1 = C1 then next row which is A2 + B2 = C2 then so on and so forth.
  Please help me. I know how to create formulas but this one i dont know.
  Any help will be greatly appreciated.
  Thanks.
  Just a simple macro is all I ned.</p>
  
  <p>Here's had came up but to no avail.</p>
  
  <pre><code>Worksheets("Total").Activate
  Set MyRange = Range("H3:H100")
  For Each mycell in MyRange
  H3 = A3+B3+C3
  (so if the next loop it will look like H4 = A4+B4+C4 and so on)
  Next mycell
  End sub
  </code></pre>