Sub Supprimelignes()
Application.ScreenUpdating = False
derlg = Range("E65536").End(xlUp).Row
For i = derlg To 6 Step -1
If Cells(i, 5) = 1 Then Rows(i).Delete
Next i
End Sub
Sub Supprimelignes()
Sheets("A").Select
Application.ScreenUpdating = False
derlg = Range("E65536").End(xlUp).Row
For i = derlg To 6 Step -1
If Cells(i, 5) = 1 Then Rows(i).Delete
Next i
End Sub
Sub Supprimelignes()
Sheets("A").Select
Application.ScreenUpdating = False
derlg = Range("E65536").End(xlUp).Row
For i = derlg To 6 Step -1
If Cells(i, 5) > 0 Then Rows(i).Delete
Next i
End Sub