AutoFilter/Advanced Filter

[cgmojoco]

I tried this code to filter more than one or statement, without any luck:

Sub Macro3()
'
' Macro3 Macro
' Macro recorded 12/5/2005 by Mitchell Employee
'

'
    Range("E1").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=5, Criteria1:="=MITCHELLRX", Operator:=xlOr, _
        Criteria2:="=MITCHELLFL", Operator:=xlOr, _
        Criteria3:="=MITCHELL"
End Sub

Is there a way to add more than two criteria?

 

[Zack Barresse]

Not with the standard Filter method, no. Sorry. There are other alternatives though. Here is one work in progress .. http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl?num=1131444088 I believe Aaron Blood was working on one some time ago, although I'm not sure if he ever finished or not.

 

[cgmojoco]

Thanks, I've moved this over to:
http://www.mrexcel.com/board2/viewtopic.php?t=183260&highlight=