Bonjour,
Un exemple.
ALT F8, exécuter la procédure.
Cdlt.
Public Sub Delete_Rows()
Dim dtm As Date
dtm = DateAdd("d", -3, VBA.Date)
With Worksheets("Rapp_ReliquatEnCommande")
If .AutoFilterMode Then .AutoFilter.ShowAllData
With .Cells(1).CurrentRegion
.AutoFilter field:=2, Criteria1:="<" & dtm * 1
.Offset(1).EntireRow.Delete
.AutoFilter
End With
End With
End Sub