Bonjour,
Une proposition équivalente.
Cdlt.
Sub FiltreSurDate2()
Dim startDate As String, endDate As String
endDate = Format(Date, "#")
startDate = Format(Date - 365, "#")
Sheets("Feuil1").AutoFilterMode = False
Sheets("Feuil1").Range("A1").AutoFilter _
Field:=9, _
Criteria1:=">=" & startDate, _
Operator:=xlAnd, _
Criteria2:="<=" & endDate
End Sub