Hi Guys,
How can I create an autofilter in many columns that contains an specific text.
If I do something like that (below), the return will be empty because it works like an AND operator and I want to work with OR.
Column B = Red OR Column C = Red
ActiveSheet.Range("$A$1:$E$1000").AutoFilter Field:=1, Criteria1:= _
"Red", Operator:=xlOr, Field:=2, Criteria2:="Red"
How can I get a result like the image attached?
Any help?
Thanks in advance
How can I create an autofilter in many columns that contains an specific text.
If I do something like that (below), the return will be empty because it works like an AND operator and I want to work with OR.
Column B = Red OR Column C = Red
ActiveSheet.Range("$A$1:$E$1000").AutoFilter Field:=1, Criteria1:= _
"Red", Operator:=xlOr, Field:=2, Criteria2:="Red"
How can I get a result like the image attached?
Any help?
Thanks in advance