macro emptying table also to work when table is empty

Hi,

I've written a macro that clears all data from several sheets so you have a blank sheet to start from the next week we run reports.
part of the data resides in tables. however not always all tables will be filled.
so when this part of the macro runs

Sheets("TBL WT").Select
Rows("2:150").Select
Selection.Delete Shift:=xlUp

and the table is empty, it has no data to remove, and therefor it doesnt and the macro stops running ( I have put it in the last position so it kinda works still)
I have a copy of this table ( callet TBL DT) which is usually filled with a couple of rows of data and that does empty with the same code.
so the only issie there is is that it 'jams' when there is no data in the table.

is there a way to rewrite the code so it does not delete when the rows are empty and the code works as meant when there is data to delete? maybe?

thanks!
Pascalle.

Could you not put an if statement in to check if the rows are empty first?

I guess, but how?

=IF ISBLANK and then? what is the code for : 'do nothing', or ignore the code. ?

Try something along these lines...

Please Login or Register  to view this content.

This assumes that if your table is empty then only the first row needs to be checked. If it is empty, the sub is exited, otherwise it processes your code.

ah that makes sense, but what if i dont want it to exit the sub entirely, but only part of the code in the sub? ( I can place this bit of the code at the end, so exiting the sub will work, butt the identical table ( "DT") might have instances where it is empty too, so I'd like to build it into that part of the macro as well.

asking too much?

does the answer lie in 'resume next'?

Originally Posted by pallie

ah that makes sense, but what if i dont want it to exit the sub entirely, but only part of the code in the sub? ( I can place this bit of the code at the end, so exiting the sub will work, butt the identical table ( "DT") might have instances where it is empty too, so I'd like to build it into that part of the macro as well.

asking too much?

You could use Go To:

Please Login or Register  to view this content.

perfect! thanks!!