How can I use a variable in an autofilter in VBA

[Ektaa]

Hi friends,

Can any one help me out,I want to use a variable where it is going to be used for autofilter.


ActiveSheet.Range("$A$1:$S$277").AutoFilter Field:=1,
Criteria1:=">=StartDate", Operator:=xlAnd, Criteria2:="<=EndDate"

Where StartDate and EndDate would be assigned date values to filter between
those dates. I am using variable name instead of the value of the variable.

Variables are dim as variants.

[Zecho]

Sure i will help you out with this issue try to use the following code hope it would work for you.

Criteria1:=">=" & StartDate

[Ektaa]

I try to follow the codes but it's not working for me and for more information i am using Excel 2002.

[Katty]

I was also facing similar kind of issue i try to use the following code and it worked for me.

Range("A1: D200").AutoFilter 2, ">=02/01/2001", xlAnd, "<=02/01/2001"