VBA Filtering with multiple criteria

  • I am trying to create a filter that will select 4 (or more) different parts based on the name of the part. Ex. Tea123

    another constraint is: Sometimes a part will be added with a similar name so I cannot specify the exact name.

    So what I started with is:

    [COLOR=#333333]ActiveSheet.Range("$A$1:$N$6000").AutoFilter Field:=4, Criteria1:="=*A717*", _[/COLOR]
    [COLOR=#333333]Operator:=xlOr, Criteria2:="=*TEA123*"

    Can I add more criteria to this formula. Right now this works for finding any part that contains "A717", or "TEA123" but I need this to also find a few other that have different names.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!