Hi,
I want to AutoFilter cell values are between (<=-11 And >=11) And between (>=-24 And <=24), thats both at the same time. Unfortunately, I'm totally lost on how to create the above range checking, any help would be much appreciated.
Here's my current code below, I can filter one way, but not both together:
With Sheet1
.AutoFilterMode = False
.Range("TrafficRange").AutoFilter Field:=1, Criteria1:="<=-11", Operator:=xlAnd, Criteria2:=">=11
.Range("TrafficRange").AutoFilter Field:=1, Criteria1:=">=-24", Operator:=xlAnd, Criteria2:="<=24
End With
I want to AutoFilter cell values are between (<=-11 And >=11) And between (>=-24 And <=24), thats both at the same time. Unfortunately, I'm totally lost on how to create the above range checking, any help would be much appreciated.
Here's my current code below, I can filter one way, but not both together:
With Sheet1
.AutoFilterMode = False
.Range("TrafficRange").AutoFilter Field:=1, Criteria1:="<=-11", Operator:=xlAnd, Criteria2:=">=11
.Range("TrafficRange").AutoFilter Field:=1, Criteria1:=">=-24", Operator:=xlAnd, Criteria2:="<=24
End With