gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Hi,
In the above code I want to add one more additonal sub criteria to Criteria2 with AND condition
for example
Rng1.AutoFilter field:=2, Criteria1:=">=" & ACel.Offset(I, -1), Operator:=xlAnd, Criteria2:=("<=" & ACel.Offset(I, -1) + 1 And ACel.Offset(I, 2) >= 0)
What is the syntax for this coding?
VBA Code:
Rng1.AutoFilter field:=10
Rng1.AutoFilter field:=18, Criteria1:="=" & ""
Rng1.AutoFilter field:=2, Criteria1:=">=" & ACel.Offset(I, -1), Operator:=xlAnd, Criteria2:="<=" & ACel.Offset(I, -1) + 1
Rng1.AutoFilter field:=8, Criteria1:="=" & unqSmpIDs(J)
In the above code I want to add one more additonal sub criteria to Criteria2 with AND condition
for example
Rng1.AutoFilter field:=2, Criteria1:=">=" & ACel.Offset(I, -1), Operator:=xlAnd, Criteria2:=("<=" & ACel.Offset(I, -1) + 1 And ACel.Offset(I, 2) >= 0)
What is the syntax for this coding?