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