Sub Recuperer_filtre()
Dim i&, n&, a(1 To 5, 1 To 2)
With [A1].CurrentRegion
For i = 2 To .Rows.Count
If Not .Rows(i).Hidden Then
n = n + 1
a(n, 1) = .Cells(i, 1)
a(n, 2) = .Cells(i, 3)
If n = 5 Then Exit For
End If
Next
'---restitution éventuelle sous le tableau---
With .Cells(.Rows.Count + 2, 1)
If n Then .Resize(n, 2) = a
.Offset(n).Resize(Rows.Count - n - .Row + 1, 2).ClearContents 'RAZ dessous
End With
End With
End Sub