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