Bonsoir,
Vous avez trouvé cette solution
Merci le forum
Sub annuler()
Dim lgn&
lgn = Range("A" & Rows.Count).End(xlUp).Row
With ThisWorkbook.Worksheets("Feuil1")
For i = 2 To lgn
If .Cells(i, 7) <> "" Then
If .Cells(i, 7) <= CDate(Format(Now, "dd/mm/yyyy")) Then
.Cells(i, 5) = ""
.Cells(i...