VBA Excel Autofilter 3 Criteria

Sub SP120others()

    Sheets("receivables").Select

    ActiveSheet.ListObjects("Table_Query_from_SME_SQL3").Range.AutoFilter Field:= _
        9, Criteria1:="<>Name One", Operator:=xlAnd, Criteria2:="<>Name Two"
End Sub

==============================================================

Would someone know how to tweak the above code to show 3 Criterias instead? Thank you.
randybucaoAsked:
Who is Participating?
 
wshark83Connect With a Mentor Commented:
you mean something like this:

ActiveSheet.ListObjects("Table_Query_from_SME_SQL3").Range.AutoFilter Field:= _
        9, Criteria1:="<>Name One", Operator:=xlAnd, Criteria2:="<>Name Two",Operator:=xlAnd, Criteria3:="<>Name Three"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.