Autofilter on multiple criteria

[WxShady13]

I have a table that I need to omit 3 options and show 10 others and I do not know how to do that. I have tried an autofilter vba code but it will only filters on 1 of the criteria. Listed below is what I need to show and not show. Thank you for your help.

Table6 is my table name

Show - DA, FE, FL, IW, LA, LT, OCC, SD, SK, UN
Do not show - BV, JD, LW, NG, VA

 

[DanteAmor]

If you want to show 10 values, then automatically all other values ​​will not be displayed. It is not necessary that you put which you do not want to show.

Try this:

    ActiveSheet.ListObjects("Table6").Range.AutoFilter Field:=4, Criteria1:= _
        Array("DA", "FE", "FL", "IW", "LA", "LT", "OCC", "SD", "SK", "UN"), Operator:=xlFilterValues

 

[WxShady13]

Thank you for the this!!! Worked like a charm

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.