Macro to Delete Dates in Col F which are Less than Date Specified in Col L

[howard]

I have dates in Col F in format dd/mm/yyyy from row 2 onwards and a specified date in Col L1 in format mmm yyyy eg Nov 2020

Where the Date in Col L1 < the dates in Col F, I would like the rows in Col F drom row 2 owards to be deleted where L1 is less than those dates in Col F


See my code below

 Sub Delete_RowsBelowMinDate()

               
        With Sheet1.[A1].CurrentRegion
                .AutoFilter 6, "< L1"
                .Offset(1).EntireRow.Delete
                .AutoFilter
        End With

End Sub

Your assistance is most appreciated

 

[vcoolio]

You're welcome Howard. Glad to have been able to assist and thanks for the feedback.

Cheerio,
vcoolio.