使用超过2个标准的自动过滤器 [英] Use autofilter on more than 2 criteria

问题描述

如何在超过2个变量上使用VBA自动过滤器 - 我不断收到错误消息：

How do you use VBA autofilter on more than 2 variables - I keep getting the error message:

未找到命名参数

Named argument not found

代码如下：

.AutoFilter Field:=1, Criteria1:="HP Compaq 6000", Operator:=xlOr, Criteria2:="HP Compaq 8000", Operator:=xlOr, Criteria3:="HP Compaq 8200", Operator:=xlOr, Criteria4:="HP Compaq 8200 Elite", Operator:=xlOr, Criteria5:="HP Compaq dc5800", Operator:=xlOr, Criteria6:="HP Compaq dc7900", Operator:=xlOr, Criteria7:="HP Compaq Elite 8300 SFF", Operator:=xlOr, Criteria8:="HP Compaq Pro 8300 SFF"

我想知道如果可以使用AutoFilter在同一列中使用超过2个条件过滤数据。如果没有，是否有另一种方式来实现这个目标？

I would like to know if it is possible to filter data with more than 2 criteria in the same column using the AutoFilter. If there isn't, is there another way to accomplish this objective?

推荐答案

使用这个：

.AutoFilter Field:=1, Criteria1:=Array("HP Compaq 6000", "HP Compaq 8000", _
                                    "HP Compaq 8200", "HP Compaq 8200 Elite", _
                                    "HP Compaq dc5800", "HP Compaq dc7900", _
                                    "HP Compaq Elite 8300 SFF", "HP Compaq Pro 8300 SFF"), _
                    Operator:=xlFilterValues

这篇关于使用超过2个标准的自动过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！