Clear data fom multiple tables

[DeanMcK]

Hi All,

I have two tables in one worksheet which I want to clear the data, leaving one row below the headers, before importing/updating the data into the tables.

I'm using the following code, which works, but would like a more streamlined approached to achieving the same results.

Please Login or Register  to view this content.

Any help appreciated

Cheers

Dean

[Roel Jongman]

Is this short enough for you?

not sure if your tables are on a worksheet with codename sheet1 but replace sheet1 with the actual sheetname
you say there are 2 tables (listobjects) on that sheet in total. so listobjects can be handeled by name or by number.
listobject(1) and listobjects(2) will be the number id's of your tables, a small loop will discard their databodyrange

Please Login or Register  to view this content.

[DeanMcK]

Thanks Roel,

very short and works a treat.

Cheers

Dean