VBA - Filer on array values contain

[mwc0914]

I am trying to filter on an array of values where the array contains wildcard criteria.
Like, filter where the column CONTAINS any of he following: SS, CASH, EOD, RDC.

I am trying this code

Dim otherarray
otherarray - Array("*SS*","*CASH*","*EOD*","*RDC*")
Actvesheet.cells.autofilter field:12, criteria=otherarray, operator:=xlfiltervalues

It is returning nothing, like it is looking for *SS* literally in the column rather than the column contains SS

 

[mwc0914]

Making progress....changed xlfiltervalues to xlor....but now it is only returning cells with RDC in them.

Also should be otherarray = Array(........

 

[JoeMo]

Untested, but see if this works for you:

Dim A1, A2
A1 = Array("*CASH*", "*SS*")
A2 = Array("*EOD*", "*RDC*")
Actvesheet.Cells.AutoFilter field:=12, Criteria1:=A1, Criteria2:=A2, Operator:=xlOr