Sub SupprimerTER()
With Sheets("espace")
Derlg = .Cells.Find("*", , , , xlByRows, xlPrevious).Row
.Range("H:I,K:K").Replace "0", ""
With .Range("P2:P" & Derlg)
.Formula = "=1/((COUNTA(H2,I2,K2)=3))"
.SpecialCells(xlCellTypeFormulas, 1).EntireRow.Delete
End With
.Range("P2:P" & Derlg) = Empty
End With
End Sub