Deleting data in a structured table but not the table

[paul_taylor]

These new tables are nice but they give me grief. I seem to have all kinds of trouble copying over or trying to refresh tables. If I try to refresh a table by copying data into a table, it works as long as the original table is not longer than the copy range. (at least the way I'm currently doing it). So a workaround would be to delete all the data in the table first, but not the headers or table structure. What's the best way to do that?

ps I tried to record a macro by starting in cell A2 and going XLright, XL down, and deleting but the macro inserted a bunch of
Selection.ListObject.ListRows(2).Delete
Selection.ListObject.ListRows(2).Delete
Selection.ListObject.ListRows(2).Delete
Selection.ListObject.ListRows(2).Delete
Selection.ListObject.ListRows(2).Delete

Lame.