Delete certain month form data list with months

Lets say I have a list with 12 months.
Then i want to load in a new month.

Say August, then the code needs to check if August is already in.
That part I already have covered.

Now looking for the elegant part that just deletes all the lines of August that are already in (the list is sorted on date).

Was thinking searching with a match for first and last occurrence and then delete those line numbers.
But must be a more elegant way? Telling VBA to delete a month without first calculating the start and endrow "myself"?

Just filter and delete ...

Just filter and delete???
It is part of a bigger part of VBA code....

This is part of this code but it does not want to work.

Please Login or Register  to view this content.

Activate the Macro Recorder then filter and delete in order to get your own code base ...

Ok maybe I should have added a sample.
What I wanted to know is why this code is not working.

Keep getting the error "Unable to get the Match property of the WorksheetFunction class"

when I hover over my variable it is 30-SEP-2022 but the value on first excel sheet is 30-09-22

Maybe that has something to do with it?

Ok found a way around it.

using application.match and Dim Double did the trick.

Please Login or Register  to view this content.

Well done !

But for a date you should use Long rather than Double ...