在Excel VBA中进行多重过滤? [英] Multiple Filtering in Excel VBA?

问题描述

我正在尝试使用2列和2种不同的过滤器要求来过滤数据.

I'm trying to filter my data using 2 columns and 2 different filter requirements.

    ActiveSheet.AutoFilterMode = False
    ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=5, Criteria1:="yes"
    ActiveSheet.Range("E:E").AutoFilter Field:=1, Criteria1:="Low"

如果我按是"进行过滤，那么它将起作用；如果我按低"进行过滤，则它也会起作用.但是，如果我尝试按是过滤K2-ZZ200范围，然后按低过滤E列，则似乎隐藏了所有内容.

If I filter by yes then it work and if I filter by Low it also works. However if I try and filter range K2-ZZ200 by yes and then Column E by Low it seems to hide everything.

有什么想法吗?

推荐答案

对于两个 /bb242013%28v=office.12%29.aspx"rel =" noreferrer> AutoFilter 语句:

You have to use the same Range("$K$2:$ZZ$200") for both AutoFilter statements:

' Column A = Field 1
ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=1, Criteria1:="yes"
' Column E = Field 5
ActiveSheet.Range("$K$2:$ZZ$200").AutoFilter Field:=5, Criteria1:="Low"

此外，您可能需要设置ActiveSheet.AutoFilterMode = True，但是我不确定.

Also, you may need to set ActiveSheet.AutoFilterMode = True, but I'm not entirely sure.

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