Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I got some good responses regarding the autofilter problem from Dave
Peterson and Debra Dalgleish. ================ to check for multiple criteria in the same column, you could use a formula like: =OR(D2="A",D2="B",D2="C") Just to save typing: =OR(D2={"A","B","C"}) Or list the multiple criteria on the worksheet, then check if the value in the current row is in the list, e.g.: =COUNTIF($K$2:$K$4,D2)0 ================ However, I don't know how to apply these. The formula I was using is: Selection.Autofilter Field:=10, Criteria1:="A" When I try to apply the "OR" example, I get an error. I have a user form that has 5 checkboxes to select the filter for the particular field. How do I build the filter phrase in VBA? GMet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |