title: Delete Table Rows
body: <p>I have a <code>Table</code> in my Excel. The table is called <code>Table1</code>.</p>
  
  <p>I want to delete the entire row except 1st row of the table which it can be done manually like select the row then delete table row, but I couldn't imagine if the row is reaching more than a million records. I tried the following code:<br></p>
  
  <pre><code>Sheet3.Range("A20","E500000").Delete 2
  </code></pre>
  
  <p>But the code above is error. The error said:</p>
  
  <blockquote>
    <p>This won't work because it would move cells in a table on your worksheet.</p>
  </blockquote>
  
  <p>Does anyone have a same problem with me? Suggestion please.</p>