Posts by JValades

  • 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:


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


    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.


    Best