Hi all

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

In essence I have this

Please Login or Register  to view this content.
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