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
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