1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub filtre_principal()
Dim Plagefiltre As Range, PlageBase As Range, cmptl As Long
Dim Zone As Range, Message As String
With ThisWorkbook.Worksheets("CC2012")
Set PlageBase = .Range(.Cells(1, 1), .Cells(1, 1)).End(xlDown).Resize(, 39)
End With
With PlageBase
'------------enlève les éventuels anciens filtres
.AutoFilter
'------------filtre la colonne St (5)
.AutoFilter Field:=5, Criteria1:=Array("2", "1", "0", "3"), Operator:=xlFilterValues, visibledropdown:=True
'cette alternance ("2", "1", "0", "3") est une liste de tri personnalisée
.AutoFilter Field:=8, Criteria1:=xlAscending, Operator:=xlFilterValues, visibledropdown:=True
' tri dans l'ordre alphabétique
End With
End Sub |
Partager