title: Add rows below last row
body: <p>I'm designing a data submission spreadsheet with 12 rows of data (currently row 22 to 33).  Rows 34 to 42 are filled with text.  I'd like to add a new row (row 34) below row 33 if more than 12 data sets are to be entered, with the same format as row 33, using a macro assigned to a button.  That's easy, but if I need another new row (now row 35) below row 34, I need a code is flexible to do that; mine always adds the new line below row 33, not below the last row of the data entry set.  How do I do this?  I'm quite new to VBA...</p>
  
  <p>Thanks,</p>
  
  <p>Andy</p>