En voulant appliquer un filtre automatique =E0 mon tableau dans la feuille =
"Base" (WS1) pour extraire des donn=E9es entre deux dates, j=92obtiens un r=
=E9sultat nulle, pourtant il y a bien une ligne qui correspond =E0 mon filt=
re :
'--------------------------------------------------------
date_debut =3D Date - Application.Choose(Application.Weekday(Date, 2), =
5, 6, 0, 1, 2, 3, 4)
date_fin =3D date_debut + 6
With WS1
If .AutoFilterMode =3D False Then .Range("A7:F7").AutoFilter
.Range("A7:F7").AutoFilter Field:=3D3, Criteria1:=3D">=3D" & Format=
(date_debut, "dd/mm/yyyy") _
, Operator:=3DxlAnd, Criteria2:=3D"<=3D" &=
Format(date_fin, "dd/mm/yyyy")
End With
Set Rng =3D [_filterdatabase].Resize(, 6).SpecialCells(xlCellTypeVisibl=
e)
Clgn =3D [_filterdatabase].Resize(, 1).SpecialCells(xlCellTypeVisible).=
Count - 1
MsgBox "Count lignes =3D " & Clgn
'-------------------------------------------------------------