tanyaleblanc
Board Regular
- Joined
- Mar 16, 2019
- Messages
- 145
I'm trying to filter using 3 criteria but I'm getting an error, here is the code I tried.
With ActiveSheet
.AutoFilterMode = False
With Range("A2:I2")
.AutoFilter
.AutoFilter field:=4, Criteria1:="Text56", Operator:=xlAnd, Criteria2:="Text76", Operator:=xlAnd, Criteria3:="Text80"
End With
End With
With ActiveSheet
.AutoFilterMode = False
With Range("A2:I2")
.AutoFilter
.AutoFilter field:=4, Criteria1:="Text56", Operator:=xlAnd, Criteria2:="Text76", Operator:=xlAnd, Criteria3:="Text80"
End With
End With