Sub test()
With ActiveSheet.ListObjects("Tableau36").Range
.AutoFilter Field:=9, Criteria1:="=Soldé"
copy destination:=sheets("archive").cells(rows.count,1).end(xlup).offset(1)
.AutoFilter
End With
MsgBox Rng.Address' donne l'adress du range soldé du tableau
End Sub