Sub Activer_Filtrage()
Set MaZone = ActiveSheet.Range("A5:M" & Cells(Rows.Count, 1).End(xlUp).Row)
Application.ScreenUpdating = False
For MaCol = 1 To 13
MaZone.AutoFilter Field:=MaCol, Visibledropdown:=False
Next MaCol
Select Case Sheets("Feuil1").Range("Q5").Value
Case 2 ' Rappels
MaZone.AutoFilter Field:=10, Criteria1:=">=1", Operator:=xlAnd
MaZone.AutoFilter Field:=11, Criteria1:="="
Case 3 ' Répondeurs
MaZone.AutoFilter Field:=10, Criteria1:="=", Operator:=xlAnd
MaZone.AutoFilter Field:=11, Criteria1:="="
MaZone.AutoFilter Field:=12, Criteria1:="<>"
Case 4 'RdVs annulés
MaZone.AutoFilter Field:=10, Criteria1:=">=1", Operator:=xlAnd
MaZone.AutoFilter Field:=11, Criteria1:="<>"
Case 5 'NON traités
MaZone.AutoFilter Field:=10, Criteria1:="=", Operator:=xlAnd
MaZone.AutoFilter Field:=11, Criteria1:="="
MaZone.AutoFilter Field:=12, Criteria1:="="
Case 6 'NPR
MaZone.AutoFilter Field:=10, Criteria1:="NPR"
Case 7 'RdV Fait
MaZone.AutoFilter Field:=10, Criteria1:="RdV Fait"
Case 8 ' RdV Facturé
MaZone.AutoFilter Field:=10, Criteria1:="RdV Fait Facturé"
' Case 9 ' n/c
' MaZone.AutoFilter Field:=26, Criteria1:="n/c"
End Select
[a2].Select
Application.ScreenUpdating = True
End Sub