I have a macro with the following statement:


Selection.AutoFilter Field:=1, Criteria1:="=5/15/2006", Operator:=xlAnd _
, Criteria2:="<=5/28/2006"

I want to replace the two dates with references to the values in cells B1
and B2 in the sheet "Macro Data". How do I do this?

Dan