Public Sub MyFilter()
Dim lngStart As Long, lngEnd As Long, dl As Long
dl = Range("B65536").End(xlUp).Row
lngStart = Sheets("Ecritures").Range("R3").Value 'assume this is the start date
lngEnd = Sheets("Ecritures").Range("R5").Value 'assume this is the end date
Range("B9:B" & dl).AutoFilter field:=1, Criteria1:=">=" & lngStart, Operator:=xlAnd, Criteria2:="<=" & lngEnd
End Sub