title: How to select clear table contents without destroying the table?
body: <p>I have a vba function in excel 2010 that I built using help from people on here. This function copies the contents of a table/form, sorts them, and sends them to the appropriate tables.</p>
  
  <p>Now after running this function I want the original table to be cleared. I can achieve this with the following code, assuming ACell has been defined as the first cell in the table.
  <code>ACell.ListObject.Range.ClearContents</code> works fine, the only problem is it deletes the table as well as the data values.</p>
  
  <p>Is there any way around this? I would rather not have to set the table up every time I enter some data.</p>