在Excel VBA中的两个日期之间进行过滤 [英] Filtering between two dates in excel vba

问题描述

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

I need help to filter between two dates and it's giving me an error:

找不到命名参数

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"

任何帮助将不胜感激！

推荐答案

如果您的日期是实际的Date值(即不是String个看起来像日期的值)，请按照以下步骤操作:

if your dates are actual Date values (i.e. not String ones looking like dates), then go like this:

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)

这篇关于在Excel VBA中的两个日期之间进行过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！