AutoFilter复数范围

Question

我正在尝试过滤一个工作表，到目前为止，我有如下所示：

Worksheet("Sheet1").Range("A1:O1").AutoFilter Field:=12, 
    Criteria1:=Array("<34", "<>21", "<>22"),
    Operator:=xlAnd

结果行中的Field[12]必须是：

• 小于34
• 不是21或22

问题是，<>22似乎正在覆盖<34和<>21。所以有可能让过滤器遵守我所有的标准吗？

Answer 1

也许：

Sub Macro1()
    ActiveSheet.Range("$A$1:$A$58").AutoFilter Field:=1, Criteria1:=Array("0", _
        "1", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "2", "20", "23", "24", "25", _
        "26", "27", "28", "29", "3", "30", "31", "32", "33", "4", "5", "6", "7", "8", "9"), Operator _
        :=xlFilterValues
End Sub