Hi all

I have tried many many many different combinations of trying to get this auto filter to work!

In essence I have this

Private Sub CommandButton2_Click()
Sheets(2).Select
Columns("A:M").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=1, Operator:=xlOr, Field:=2, Criteria1:=Array("1", "2", "3"), Operator:=xlFilterValues, Operator:=xlAnd, Field:=13, Criteria2:=Cells(1, 29)
End Sub
What I am trying to do is basically, in English, if column a or b contains a 1,2 or 3, and column M contains the value of cells(1,29) then display these results.

This results in Wrong number of arguments (Error 450)

I have tried running three filters separate for each condition, however this always displays no results, If I remove either the field 1 or 2 condition and just leave the other it works fine.

Where am I going wrong? I have a php background so I am used to chaining queries, probably not the correct approach in VBA!

Many thanks
Dave
Excel 2007