Help with a "type mismatch" error in a macro

[dgarber]

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.

[BadlySpelledBuoy]

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

[JohnTopley]

I have run your code without any problem BUT you did not define what an invalid date is - simply less than 01/01/2021?

With valid Excel dates it worked OK

[dgarber]

That did the trick. THANK YOU!

[dgarber]

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

[BadlySpelledBuoy]

Happy to help

BSB