jardenp
Active Member
- Joined
- May 12, 2009
- Messages
- 373
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
Is there a limit to the number of criteria you can use with a filter? I want to filter out any cells that contain "RF" or "53100", or "53101", ... or "53110"
The VB debugger keeps stopping at this when I run my macro:
ActiveSheet.Range("$A$1:$A$1174").AutoFilter Field:=1, Criteria1:="=*RF*", _
Operator:=xlOr, Criteria2:="=*53100*", _
Operator:=xlOr, Criteria3:="=*53101*", _
Operator:=xlOr, Criteria4:="=*53102*", _
Operator:=xlOr, Criteria5:="=*53103*", _
Operator:=xlOr, Criteria6:="=*53104*", _
Operator:=xlOr, Criteria7:="=*53105*", _
Operator:=xlOr, Criteria8:="=*53106*", _
Operator:=xlOr, Criteria9:="=*53107*", _
Operator:=xlOr, Criteria10:="=*53108*", _
Operator:=xlOr, Criteria11:="=*53109*", _
Operator:=xlOr, Criteria12:="=*53110*"
Any suggestions what the problem is?
Thanks!
- Josh in IN
The VB debugger keeps stopping at this when I run my macro:
ActiveSheet.Range("$A$1:$A$1174").AutoFilter Field:=1, Criteria1:="=*RF*", _
Operator:=xlOr, Criteria2:="=*53100*", _
Operator:=xlOr, Criteria3:="=*53101*", _
Operator:=xlOr, Criteria4:="=*53102*", _
Operator:=xlOr, Criteria5:="=*53103*", _
Operator:=xlOr, Criteria6:="=*53104*", _
Operator:=xlOr, Criteria7:="=*53105*", _
Operator:=xlOr, Criteria8:="=*53106*", _
Operator:=xlOr, Criteria9:="=*53107*", _
Operator:=xlOr, Criteria10:="=*53108*", _
Operator:=xlOr, Criteria11:="=*53109*", _
Operator:=xlOr, Criteria12:="=*53110*"
Any suggestions what the problem is?
Thanks!
- Josh in IN