vba autofilter two columns

[david.j.winfield]

I would like to be able to filter a sheet based off of two columns in
VBA. If I run the following one at a time I can filter based off the
one column, but if I run them both it will not work.

Worksheets("Master Index").Range(Cells(12, 42), Cells(65536,
42)).AutoFilter field:=1, Criteria1:="E", Operator:=2, Criteria2:="M/
E"

Worksheets("Master Index").Range(Cells(12, 163), Cells(65536,
163)).AutoFilter field:=1, Criteria1:="1", Operator:=2, Criteria2:="1"

Also, what is the field option used for?

Thank you for your help,
David

 

[Ron de Bruin]

Normal your range is more then one column and you use the field to tell which column you want to filter.

See the example on this page and the tips below the macro
http://www.rondebruin.nl/copy5.htm#AutoFilter

 

[Guest]

Worksheets("Master Index").Range(Cells(12, 42), Cells(65536,
163)).AutoFilter field:=1, Criteria1:="E", Operator:=2, Criteria2:="M/
E"

Worksheets("Master Index").Range(Cells(12, 42), Cells(65536,
163)).AutoFilter field:=122, Criteria1:="1", Operator:=2, Criteria2:="1"

This should do it. The Field statement identifies the column number within
the range of columns you have selected for the autofilter. 1 is column 42,
122 is column 163 in your code.

 

[david.j.winfield]

Thank you for your help. Just before I saw you post, I found another
website that also explains auto filtering. Here is a link to this
source:
http://www.ozgrid.com/VBA/autofilter-vba-criteria.htm

Thanks,
David