VBA filter, how to add additonal filter

[2avrham]

Hi all,

I have the next VBA code that filter on two items: "hold" & "wip"


ActiveSheet.Range("$A$5:$T$5").AutoFilter Field:=11, Criteria1:="=HOLD", _
Operator:=xlOr, Criteria2:="=WIP"

My Q is how i can add third filter of "Future wip" for this code, i was sure it will be simple but i miss something here because after i add Criteria3:="=future wip", I'm getting errors.

Thanks!

 

[jmacleary]

Hi there. You need to use an array. Try:

ActiveSheet.Range("$A$5:$T$5").AutoFilter Field:=11,  Criteria1:=Array("HOLD","WIP", "future wip"), Operator:=xlFilterValues

 

[2avrham]

Thanks a lot it solved my issue!