Deleting tables with macros


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?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!