title: How to insert a new row into a range and copy formulas
body: <p>I have a named range like the following covering A2:D3</p>
  
  <pre><code>ITEM    PRICE   QTY SUBTOTAL
  1           10  3   30
  1           5   2   10
             TOTAL:   40
  </code></pre>
  
  <p>I am to insert a new row using VBA into the range copying the formulas not values.</p>
  
  <p>Any tips/links greatly appreciated.</p>