Help with a "type mismatch" error in a macro

Hi All,

I have a worksheet that receives imported data from another worksheet. Occasionally there are invalid dates imported and we want
to delete those rows with the macro below. The expectation is that it deletes all dates prior to 1/1/2021.
It does the job as expected BUT I'm getting a type mismatch error when the macro has finished and I'm not sure why?
I assumed it was date format but have tried every which way to no avail.

Any help would be great.
Thanks,
D

Please Login or Register  to view this content.

Do you have text headers in row 1?

If so, try amending this line:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

BSB

That did the trick. THANK YOU!

I was able to get it. As previous post indicated "Text Headers" were causing and issue in Row 1. Thank you!

Happy to help

BSB