Excel 2003 - VBA - Autofilter, more than 2 criteria?

[AdamParker]

Hello all,
I am trying to autofilter in VBA (Excel 2003), it looks like I am limited to two criteria.. is there a way around this?

Basically I have a list of users and roles, they can have about 50 different roles, I'm trying to have this macro filter out 4 different roles, and copy these users and their roles to a different sheet.

I can do it for two of them no problem, and I know that I could do it twice, but I am trying to keep it simple as I am trying to avoid having to copy them to the different sheet, go back, re-autofilter, go to other sheet, find last row, paste below..

So, basically I know how to do it in a long way, but I also view these as a learning experience so I'm wondering what some experienced people think.. As always, any help you guys can provide is appreciated..

Thanks!

Adam

[romperstomper]

Either use an advanced filter (which needs a criteria range) or use an additional formula column that checks to see if each row matches one of your 4 criteria, then autofilter for TRUE in the additional column.