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