Sub Etat()
Dim AF As Object, mes$, i%
Set AF = ActiveSheet.AutoFilter
If AF Is Nothing Then MsgBox "Filtre automatique non installé...": Exit Sub
For i = 1 To AF.Filters.Count
mes = mes & vbLf & "Filtre sur " & AF.Range.Columns(i).Address(0, 0) & " => " & IIf(AF.Filters(i).On, "", " non ") & "actif"
Next
MsgBox Mid(mes, 2), , "Filtre automatique"
End Sub