Deleting tables with macros

Closed
Bo - Sep 8, 2015 at 11:56 AM
Hello,

I've got a long dataset.

At some point in the sheet there are tales that start with a row with a text in the first cell "Please specify" and last row of the table with a text in first cell "Valid".

I need to delete such tables, they are 5 rows in length every time.

Can anyone suggest how to do with macros?

Or maybe there is any other way?

Thanks!