Bonsoir le fil, bonsoir le forum,
Désolé, il y avait juste un espace en trop (Range("G1:G " etc.)...
Le code modifié :
Sub Macro1()
Dim CEL As Range
Dim PL As Range
Set PL = Range("A1")
For Each CEL In Range("G1:G" & Cells(Application.Rows.Count, 7).End(xlUp).Row).SpecialCells(xlCellTypeConstants)
If CEL.Value = 0 Then
Set PL = IIf(PL.Address = "$A$1", Rows(CEL.Row), Application.Union(PL, Rows(CEL.Row)))
End If
Next CEL
PL.Delete
End Sub