title: Excel VBA: How to Insert formula into an area of cells?
body: <p><strong>Problem</strong>  </p>
  
  <p>I need to insert some formulas into a 2 dimensional area of cells with VBA. For example below</p>
  
  <p><img src="https://i.stack.imgur.com/LCwGq.jpg" alt="Excel Range sample"></p>
  
  <p>Of course I can do this for 1 row with VBA using the .Formulas = "=Sum(....)"</p>
  
  <p>but how can I include an area instead of just a range? This seems so trivial but I can't seem to figure it out. I'm trying to avoid using a loop to fill out every row.</p>