vba - 在excel vba中的两个日期之间过滤

Question

我需要帮助在两个日期之间进行过滤，这给了我一个错误:

Named argument not found

我的代码

Dim StartDate As String
Dim EndDate As String
'
StartDate = Date
EndDate = Date + 365
'
ActiveSheet.AutoFilter Field:=7, Criteria1:=">=StartDate", Operator:=xlAnd, Criteria2:="<=EndDate"

任何帮助将非常感激!

Answer 1

如果你的日期是真实的Date值(即不是 String 看起来像日期的值)，然后像这样:

Dim StartDate As Date
Dim EndDate As Date
StartDate = Date
EndDate = Date + 365
ActiveSheet.Range("A1:AO1").AutoFilter Field:=7, Criteria1:=">=" & CDbl(StartDate), Operator:=xlAnd, Criteria2:="<=" & CDbl(EndDate)