Private Sub CommandButton1_Click()
Dim I&, J&, K&, MinA&, MaxA&, MinB&, MaxB&, T As Variant
K = 1
With Sheets("Feuil1")
MinA = .[d1]: MaxA = .[e1]
MinB = .[f1]: MaxB = .[G1]
T = .Range("A1:B" & .Cells(Rows.Count, 1).End(xlUp).Row)
End With
For I = 2 To UBound(T, 1)
If Not (T(I, 1) < MinA Or T(I, 1) > MaxA Or _
T(I, 2) < MinB Or T(I, 2) > MaxB) Then
K = K + 1
For J = 1 To UBound(T, 2)
T(K, J) = T(I, J)
Next J
End If
Next I
Application.ScreenUpdating = False
Columns(1).Resize(, UBound(T, 2)).ClearContents
Range("A1").Resize(K, UBound(T, 2)) = T
Application.ScreenUpdating = True
End Sub