title: Delete all data rows from an Excel table (apart from the first)
body: <p>Just recently I've been trying to delete all data rows in a table, apart from the first (which needs to just be cleared)</p>
  
  <p>Some of the tables being actioned could already have no rows, so I was running it to problems as using <code>.DataBodyRange.Rows.Count</code> on a table with no rows (just header and/or footer) causes errors.</p>
  
  <p>I looked all over for a solution an could not find a whole one, so I hope my answer to this question will be useful to others in the future.</p>