Filter column using criteria from a userform

[Eileen]

I would like to filter a column based on criteria entered
into a userform. I've got this code so far using actual
dates:
Selection.AutoFilter Field:=51, Criteria1:=">=01/06/2003",
Operator:= _
xlAnd, Criteria2:="<=30/10/2003"

BUT, I want to substitute the dates for variables that
come from a date picker on the userform, ie >=variablename
I've tried:
Criteria1:= >= variablename
Criteria1:= ">=" variablename
Criteria1:= ">=variablename" - this picks up the words,
not the variable

But none of them work - what syntax do I use?

Please help.
Thanks

 

[Debra Dalgleish]

Use an ampersand to join the operator and variable:

Selection.AutoFilter Field:=51, Criteria1:=">=" & Variable1, _
Operator:=xlAnd, Criteria2:="<=" & Variable2