Filtering a column with an array of specific numbers

[Xcels]

Hi there,

I am trying to filter a column in Field 16 for the following numbers 2,3,4,6

My code is as follows:
Range("A1").Select
Selection.End(xlUp).Select
Selection.End(xlToLeft).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.AutoFilter Field:=16, Criteria1:=Array("2", "3", "4", "6"), Operator:=x1FilterValues

There seems to be an issue, but I don't understand why it won't work. I would really appreciate the help.

Thank you,

 

[kevin9999]

Please provide a sample of your data using the XL2BB add in.

 

[Fluff]

It should be xlFilterValues (lower case L) not x1FilterValues (number one)

 

[Xcels]

Thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.