Selection.AutoFilter Field:=9, Criteria1:="=" &
cdate(Extractions.LDDate1.Date), Operator:=xlAnd,
Criteria2:="<=" & cDate(Extractions.LDDate2.Date)

would be a guess
--
Regards,
Tom Ogilvy



wrote in message
oups.com...
Hello everyone,
I tought I could find the answer by myself and not disturb you, but it
have 2/3 days that I've been searching solutions to my problem through
the NG and did not find any anwser.

Here is my problem :
I have programmed an autofilter under VB in Excel...the thing is that
when I run it from a userform...the autofilter is empty. And when i
have a look in the "personnalised"...my criteria are correct..so I
click on the OK button and finally the filtered data are displayed.....
What I don't understand is why those data are not displayed
automatically.

Here is my piece of VB program (which is very basic VB!!!) :

Rows("5:5").Select ' this select the entire line where there are the
titles of the columns
Selection.AutoFilter
Selection.AutoFilter Field:=9, Criteria1:="=" &
Format(Extractions.LDDate1.Date, "dd/mmm/yyyy"), Operator:=xlAnd,
Criteria2:="<=" & Format(Extractions.LDDate2.Date, "dd/mmm/yyyy")

nota : extractions is my userform, LDDate1 & LDDate2 are the databox
which gives the criterion for the autofilter.

thanks in advance for anyhelp, I really don't know what to do....

Angélique