autofilter problem

[philfer]

Hello,

In my code I have :-

[vba]With Worksheets("GBP")

.Rows("1:1").AutoFilter
.Range("$A$1:$G$25000").AutoFilter Field:=1, Criteria1:= _
">=" & StartFilterStart, Operator:=xlAnd, Criteria2:="<=" & StartFilterEnd

End[/vba]
If I do debug.print for StartFilterStart and StartFilterEnd I get :-

01/09/2010
30/09/2010

As I use DateAdd to get the start and end of a month

However the autofilter filters on between :-

09/01/2010
30/09/2010

My system date is UK

Does anyone know why this is happening?

Thanks
Phil

[Bob Phillips]

I tend to use

[vba]

.Range("$A$1:$G$25000").AutoFilter Field:=1, Criteria1:= _
">=" & Format(StartFilterStart, .Range("$A$2).Numberformat), Operator:=xlAnd, Criteria2:="<=" & Format(StartFilterEnd, .Range("$A$2).Numberformat)
[/vba]