Clear data from multiple tables - modify code

[nickytraps]

Hi All,

I am using the below to clear out an existing table. Is there an easy way to modify this to perform the same command on multiple tables within the same sheet? Please note there is a pivot table that I want to ensure remains unchanged as I clear out these tables. Any help is greatly appreciated. Thank you.

Please Login or Register  to view this content.

[Sintek]

Perhaps...

Please Login or Register  to view this content.

[nickytraps]

Hi Sintek,

Thank you for the reply, I really appreciate it. I actually just tested a very similar code which appears to work well (complete code below). It is almost identical to yours, however I added an IF clause for error handling. Thanks again!

Please Login or Register  to view this content.

[Sintek]

Great going...That is how one learns...

Please remember to mark thread as solved...