B
BruceJ
I have 2 autofilters and I want to combine them with an OR
Here are the autofilters (they both are currently filtering between times)
Sub time8_11()
'
' time8_11 Macro
' Macro recorded 9/18/2003 by
'
'
Selection.AutoFilter Field:=32, Criteria1:=">.333", Operator:=xlAnd, _
Criteria2:="<=.458"
End Sub
Sub time4_930()
'
' time4_930 Macro
' Macro recorded 9/18/2003 by
'
'
Selection.AutoFilter Field:=32, Criteria1:=">.6666", Operator:=xlAnd, _
Criteria2:="<=.8953"
End Sub
Basically, it would be like:
Selection.AutoFilter Field:=32, (Criteria1:=">.6666", Operator:=xlAnd, _
Criteria2:="<=.8953"), Operator:=xlOr, (Criteria1:=">.333",
Operator:=xlAnd, _
Criteria2:="<=.458")
purpose is to look at records with times between (8am and 11am) or (4pm and
9:30pm)
But this did not work...
Thanks!
Bruce
Here are the autofilters (they both are currently filtering between times)
Sub time8_11()
'
' time8_11 Macro
' Macro recorded 9/18/2003 by
'
'
Selection.AutoFilter Field:=32, Criteria1:=">.333", Operator:=xlAnd, _
Criteria2:="<=.458"
End Sub
Sub time4_930()
'
' time4_930 Macro
' Macro recorded 9/18/2003 by
'
'
Selection.AutoFilter Field:=32, Criteria1:=">.6666", Operator:=xlAnd, _
Criteria2:="<=.8953"
End Sub
Basically, it would be like:
Selection.AutoFilter Field:=32, (Criteria1:=">.6666", Operator:=xlAnd, _
Criteria2:="<=.8953"), Operator:=xlOr, (Criteria1:=">.333",
Operator:=xlAnd, _
Criteria2:="<=.458")
purpose is to look at records with times between (8am and 11am) or (4pm and
9:30pm)
But this did not work...
Thanks!
Bruce