Trying to use autofilter and have more than two criteria, but doesn't seem to like my code. Any suggestions?
Selection.AutoFilter Field:=3, Criteria1:="=North", Operator:=xlOr, _
Criteria2:="=11", Operator:=xlOr, Criteria3:="=22", Operator:=xlOr, _
Criteria4:="=23", Operator:=xlOr, Criteria5:="=30"
Also, when you use only 1 criteria, is records it as Criteria1:="North" but if a second criteria is added, it becomes Criteria1:="=North". Why is the second = sign added?
Selection.AutoFilter Field:=3, Criteria1:="=North", Operator:=xlOr, _
Criteria2:="=11", Operator:=xlOr, Criteria3:="=22", Operator:=xlOr, _
Criteria4:="=23", Operator:=xlOr, Criteria5:="=30"
Also, when you use only 1 criteria, is records it as Criteria1:="North" but if a second criteria is added, it becomes Criteria1:="=North". Why is the second = sign added?