Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am working on a macro to filter out a column in Excel 2003. but i am
facing a problem in the Custom option of Auto filter, it can check for only 2 values using And / Or Selection.AutoFilter Field:=5, Criteria1:="=a", Operator:=xlOr,Criteria2:="=b" Is there any way to increase this to more than 2 values? I have also tried Selection.AutoFilter Field:=5, Criteria1:="=a", Operator:=xlOr, Criteria2:="=b", Operator :=xlOr,Criteria3:="=c" but still no joy. I have also tried putting the Criteria as an array, as used in excel 2007, but those dont work in excel 2003 ActiveSheet.Range("$A$1:$AP$437").AutoFilter Field:=2, Criteria1:=Array( "a", "b", "c") , Operator:=xlFilterValues Is there any solution for this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Filtering - Limitations of the "Contains" option | Excel Worksheet Functions | |||
help in filtering in excel 2003 | Excel Discussion (Misc queries) | |||
Help in Filtering in excel 2003 | Charts and Charting in Excel | |||
Excel 2003 Filtering | Excel Discussion (Misc queries) | |||
My custom fill color option is not in excel how do i get it worki. | Excel Discussion (Misc queries) |