filters

[jrh]

I am trying to filter with three criteria. is this too
much criteria? with 2 criteria it works, with three it
does not.

here is the code with 3 criteria which are defined earlier

Selection.AutoFilter Field:=3, Criteria1:="<>" &
Filter1, Operator:=xlAnd, _
Criteria2:="<>" & Filter2, Operator:=xlAnd,
Criteria3:="<>" & Filter3

thank you!

 

[Jim Rech]

When you do a custom autofilter manually you see there is a limit of 2
conditions. That same limit applies when you do the autofilter by a macro.

--
Jim Rech
Excel MVP
|I am trying to filter with three criteria. is this too
| much criteria? with 2 criteria it works, with three it
| does not.
|
| here is the code with 3 criteria which are defined earlier
|
| Selection.AutoFilter Field:=3, Criteria1:="<>" &
| Filter1, Operator:=xlAnd, _
| Criteria2:="<>" & Filter2, Operator:=xlAnd,
| Criteria3:="<>" & Filter3
|
| thank you!