Bon, j'ai trouvé la solution pour ceux et celles à qui ça intéresse:
Sub FilterData()
Dim ws As Worksheet, lo As ListObject, dt As Date, Rng As Range, Cell As Range, dt0 As Date, dt1 As Date
Application.ScreenUpdating = False
Set ws = ActiveSheet
Set lo = ws.ListObjects(1)
dt = Date - 14
dt0 = DateSerial(Year(Now), Month(Now), Day(Now))
dt1 = DateSerial(Year(Now), Month(Now) + 2, 1)
With lo
'If .ShowAutoFilter Then .AutoFilter.ShowAllData
.Range.AutoFilter field:=1, Criteria1:="<" & CLng(dt)
On Error Resume Next
.ListColumns(2).DataBodyRange.SpecialCells(xlCellTypeVisible) = "X"
.Range.AutoFilter field:=1
End With
With lo
.Range.AutoFilter field:=1, Criteria1:=">=" & CLng(dt0), Operator:=xlAnd, Criteria2:="<=" & CLng(dt1)
On Error Resume Next
.ListColumns(3).DataBodyRange.SpecialCells(xlCellTypeVisible) = "X"
.Range.AutoFilter field:=1
End With
End Sub
Merci chers passionés pour votre support et bonne journée!