for each cell in range ("A5:A100")
if cell <> 10 then [COLOR=red]cell.row.delete 'J'ai un doute sur la syntaxe voir avec [B]Henry[/B] :))[/COLOR]
next
Dim i As Integer
For i = 100 To 1 Step -1
If Cells(i, 1) <> 10 Then Rows(i).Delete
Next i
Sub Macro1()
Range("D2").FormulaR1C1 = "=OR(RC[-1]=300,RC[-1]=600,RC[-1]=800,RC[-1]=900)"
Range("A1:C15").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("D1:D2"), Unique:=False
End Sub