Sub Macro1()
Selection.AutoFilter Field:=6, Criteria1:=Range("J2")
End Sub
Sub test()
Dim LE_CRIT As String
LE_CRIT = Range("J2")
Selection.AutoFilter Field:=6, Criteria1:=">=" & LE_CRIT
End Sub
Sub test_II()
Dim LE_CRIT
LE_CRIT = ActiveSheet.Range("J2").Value
Selection.AutoFilter
Selection.AutoFilter 6, ">" & LE_CRIT, xlAnd
End Sub
Sub test_IV()
Dim LE_CRIT
LE_CRIT = ActiveSheet.Range("J2").Value
If MsgBox("Si Click OUI | Le critère est : >= " _
& LE_CRIT & Chr(13) & " Click NON | Le critère est : <= " _
& LE_CRIT, vbQuestion + vbYesNo, "Filtrage") = vbYes Then
Selection.AutoFilter
Selection.AutoFilter 6, ">=" & LE_CRIT
Else
Selection.AutoFilter
Selection.AutoFilter 6, "<=" & LE_CRIT
End If
End Sub