我想過濾過去5天內的所有條目，但我找不到我哪里做錯了。以下是代碼
Dim todayDate As Date
Dim fiveDaysAgo As Date
todayDate = Date[/span
fiveDaysAgo = DateAdd("d"/span>, -4, todayDate)
ActiveCell.Rows("1:1").EntireRow.Select。
選擇.自動過濾
ActiveSheet.Range(Selection, Selection.End(xlDown)).AutoFilter Field:=6, Criteria1:= _
">=fiveDaysAgo"/span>, Operator:=xlAnd, Criteria2:="<=todayDate"/span>
ActiveCell.Rows("1:1").EntireRow.Select。
過濾器不起作用，我得到的是NULL條目，而如果我在代碼中輸入特定的日期，它就會像魅力一樣作業。任何幫助都將是拯救生命的。謝謝
。uj5u.com熱心網友回復：
你需要用&將變數與字串連接起來：
">="& fiveDaysAgo
并且
"<=" & todayDate
你可能會從閱讀以下內容中受益 如何避免在Excel VBA中使用選擇功能.
。Dim todayDate As Date
todayDate = Date As
Dim fiveDaysAgo As Date
fiveDaysAgo = DateAdd("d"/span>, -4, todayDate)
ActiveCell.EntireRow.AutoFilter
ActiveSheet.Range(ActiveCell.EntireRow, ActiveCell.EntireRow.End(xlDown)).AutoFilter Field:=6, Criteria1:= _
">=" & fiveDaysAgo, Operator:=xlAnd, Criteria2:="<=" & todayDate
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/307518.html
標籤：
上一篇：保存用戶的所有輸入