Sub Macro1()
'
' Macro1 Macro
' Macro enregistrée le 20/05/2009 par VBACrumble
'
Dim pf As Range
Sheets("ABC").Range("A1:A11").Name = "CRIT"
With Sheets(1)
Set pf = .Range("_FilterDataBase")
.Range("A1:A" & .[A65536].End(xlUp).Row).AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("CRIT"), Unique:=False
pf.Offset(1, 0).Resize(pf.Rows.Count - 1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
.ShowAllData
End With
End Sub