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
Your assistance is most appreciated
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
Code:
Sub Delete_RowsBelowMinDate()
With Sheet1.[A1].CurrentRegion
.AutoFilter 6, "< L1"
.Offset(1).EntireRow.Delete
.AutoFilter
End With
End Sub
Your assistance is most appreciated