Sub FiltreAvancé()
Dim F1 As Worksheet, F2 As Worksheet, critere As Range
Set F1 = Sheets("histo")
Set F2 = Sheets("HistoFilter")
Set critere = F2.[C1:C2]
critere(2) = "=AND(ROUND(histo!A2,6)>=ROUND(A$2,6),ROUND(histo!A2,6)<=ROUND(B$2,6))"
F1.[A1].CurrentRegion.AdvancedFilter xlFilterCopy, critere, F2.[A5:G5]
'critere = "" 'facultatif
F2.Activate
End Sub