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

On Aug 27, 4:00 pm, "Ron de Bruin" wrote:
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 macrohttp://www.rondebruin.nl/copy5.htm#AutoFilter

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

wrote in oglegroups.com...
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