Option Explicit
Sub InverserFiltrage()
Dim col%, d As Object, i&, crit
col = 1 'colonne de filtrage, à adapter
Set d = CreateObject("Scripting.Dictionary")
With [A1].CurrentRegion 'à adapter
For i = 2 To .Rows.Count
If .Rows(i).Hidden Then d(.Cells(i, col).Text) = ""
Next
If d.Count Then crit = d.keys Else crit = "="
.AutoFilter col, crit, xlFilterValues
End With
End Sub