Sub sauve_filtre()
Dim f As Long
Dim col As Integer
Dim iItem As Long
Set w = ActiveWorkbook.ActiveSheet
w.Range("Tableau1[[#Headers],[montant]]").AutoFilter
With w.AutoFilter
currentFiltRange = .Range.Address
With .Filters
col = .Count
ReDim filterArray(1 To col, 1 To 4)
For f = 1 To col
With .Item(f)
filterArray(f, 1) = .On
If .On Then
filterArray(f, 2) = .Operator
If .Operator = 7 Then
MultiSelect = ""
For iItem = LBound(.Criteria1) To UBound(.Criteria1)
MultiSelect = MultiSelect & IIf(MultiSelect = "", "", delim) & .Criteria1(iItem)
Next iItem
filterArray(f, 3) = MultiSelect
Else
filterArray(f, 3) = .Criteria1
If .Operator = 1 Or .Operator = 2 Then
filterArray(f, 4) = .Criteria2
End If
End If
End If
End With
Next f
End With
End With
w.Range("Tableau1[[#Headers],[montant]]").AutoFilter
End Sub