Sub supprimer()
Dim derligne As Integer
Dim cell As Range
derligne = Range("A1").End(xlUp).Row
For Each cell In Range("A1:A" & derligne)
Set cible = Application.Find(2, cell.Value, 1)
If Not cible Is Nothing Then
cell.EntireRow.Select
Selection.Delete Shift:=xlUp
End If
Next cell
End Sub