excel question not pertaining to Macro Scheduler

Rory · Post by **Rory** » Tue Feb 12, 2008 9:18 pm

I am trying to set up a macro inside of Excel to filter more than two items. I have been able to get it to do 2 but no more than that.

This is what the code looks like in excel:

Selection.AutoFilter Field:=6, Criteria1:="=*R @ 001*", Operator:=xlOr, _
Criteria2:="=*A @ 001*"

Does anybody have experience with this? How can I add additional criteria?

Thanks,
Rory

Me_again · Post by **Me_again** » Tue Feb 12, 2008 10:55 pm

A little googling reveals that AutoFilter will only take a maximum of two criteria and that Advanced Filter in VBA may help.