I need to be able to use variables as my criteria for an autofilter which I run through VBA. I know how to use the xlAnd operator to create a custom autofilter based on 2 static values e.g.:
Selection.AutoFilter Field:=1, Criteria1:=">=5", Operator:=xlAnd, 'Criteria2:="<=10"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.