VBA Autofilter With Multiple "Ors"

[CONFUSED_AS_USUAL]

The macro below works fine upto and including Criteria2. I manually added Criteria3 using Criteria2 as a template. It does not work.

What syntax am I missing ?

Thx



Sub X_3B()
'
' X_3B Macro
'


'
Range("F4").Select
ActiveSheet.Range("$A$4:$AD$150000").AutoFilter Field:=6, Criteria1:="=3B*" _
, Operator:=xlOr, Criteria2:="=CG*"_, Operator:=xlOr, Criteria3:="=AN*"
End Sub

 

[Fluff]

Autofilter can only handle 2 criteria unless you are doing an exact match.
Have a look at advanced filters, or another option is to add a formula into a blank column that indicates which rows should be visible & filter on that.

 

[CONFUSED_AS_USUAL]

Will do. Thanks for the tip Fluff.

 

[Fluff]

You're welcome & thanks for the feedback