I am looking for way to clear an Excel Table with a macro. The table is a named table in Excel format. I am using this to download and clean up data. There are some calculated columns at the end. I just want to be able to copy into a blank table. I have functionality to automatically clean the data, but I cannot seem to get it to clear all the way to the bottom of the table. The number of rows will be variable.