AutoFilter xlOr Operator w/ MORE than 2 criteria

[idlewyld89]

So I'm aware of the xlOr operator to specify up to two unique criteria to be identified and filtered:

Worksheets(MainSheet).ListObjects("FleetStatusDetail").Range.AutoFilter Field:=ReturnHeaderIndex(ThisWorkbook.Name, MainSheet, "FleetStatusDetail", "Hold Codes"), Criteria1:="=*B*", Operator:=xlOr, Criteria2:="=*O*"

However I'm trying to determine how to scale this up to 5+ criteria... I've seen the array method, but it doesn't seem to produce the correct output:

Worksheets(MainSheet).ListObjects("FleetStatusDetail").Range.AutoFilter Field:=ReturnHeaderIndex(ThisWorkbook.Name, MainSheet, "FleetStatusDetail", "Hold Codes"), Criteria1:=Array("G", "J", "W"), Operator:=xlFilterValues

Is there a way of implementing an AutoFilter with the xlOr operator across 5+ criteria?

 

[Fazza]

hi,

Code like you posted worked for me on a simple set up of range A1 header & cells under. Not any sort of list object table. Just a dumb list.

Range("A1").AutoFilter Field:=1, Criteria1:=Array("G", "J", "W"), Operator:=xlFilterValues

So, suggest you investigate the object reference being used - ListObjects("FleetStatusDetail")

Or use an alternative reference

HTH

PS. Best too to double check that the function ReturnHeaderIndex etc does what you're expecting.

 

[Fluff]

If you are trying to filter for records containing a value (as shown in your first code) then there is a maximum of 2.
Using an array has to be an exact match