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,
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,