'A METTRE DANS UN MODULE STANDARD
Option Explicit
Sub Suppression()
Dim plage As Range, derlig As Long, lig As Long, i As Long, critere As String
With Sheets(1)
lig = .Range("e" & Rows.Count).End(xlUp).Row
Set plage = .Range("a1:i" & lig)
critere = "x"
plage.AutoFilter Field:=5, Criteria1:=critere, Operator:=xlAnd
derlig = .Cells(Rows.Count, 5).End(xlUp).Row + 1
For i = derlig To 2 Step -1
If .Cells(i, 5) Like "*" & critere Then _
.Rows(i).SpecialCells(xlCellTypeVisible).EntireRow.Delete
Next i
End With
plage.AutoFilter
End Sub
'ET DANS LE MODULE DE LA FEUILLE
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Call Suppression
Cancel = True
End Sub