ActiveSheet.Range("$A$1:$P$6").AutoFilter Field:=12, Criteria1:= " >=2011-6-21 ", Operator:=xlAnd, Criteria2:=">=2011-6-27"
各位,我想把上面的两个日期用a=cells(2,14) b=cells(2,15)替代上面日期,怎样表达?
ActiveSheet.Range("$A$1:$P$6").AutoFilter Field:=12, Criteria1:= " >=a ", Operator:=xlAnd, Criteria2:=">=b"这样有问题
|