title: Add row to the bottom of table
body: <p>I'm trying to make a very simple VBA macro to add a new row to the bottom of the table. This is what I have so far:</p>
  
  <pre><code>Sub AddRow()
      Dim LR As Long
      LR = Range("A" &amp; Rows, Count).End(xlUp).Row
      Rows(LR).Copy
      Rows(LR + 1).Insert
  End Sub
  </code></pre>
  
  <p>When I try to run this, it says out of memory. What I am trying to achieve is a new row at the bottom of my existing table (with content in column A) that I will eventually use to total up the numbers above it, no matter how many columns there are above. What have I done wrong here?</p>