Delete Entire Row on Every Sheet if Date Condition Matches

[c052463]

What I am trying to do is filter 2nd column(B) for every row for every sheet and delete if the condition matches; ">11/12/2019" in case of the following code.

The code would run into 1004 on the first sheet where the condition was matched.

Please Login or Register  to view this content.

Sample Data:

Blah	Date	AnotherBlah	BlahAgain	Woof	WoofAgain	WoofWoof	LastOne
Blah1	10/12/2019	AnotherBlah1	BlahAgain1	Woof1	WoofAgain1	WoofWoof1	LastOne1
Blah2	09/12/2019	AnotherBlah2	BlahAgain2	Woof2	WoofAgain2	WoofWoof2	LastOne2
Blah3	13/12/2019	AnotherBlah3	BlahAgain3	Woof3	WoofAgain3	WoofWoof3	LastOne3

Can you please help me spot what went wrong and why?

[Mumps1]

Try:

Please Login or Register  to view this content.

[c052463]

Thanks man my head is mush right now and you helped me get through this.

Here's the final code I did to do it to all sheets.

Please Login or Register  to view this content.

[Mumps1]

Are you sure that it worked properly? I would think the macro should be something like this:

Please Login or Register  to view this content.