Thread: filters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jrh jrh is offline
external usenet poster
 
Posts: 14
Default filters

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!