Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am trying to run a custom filter on a column, returning results if any of three values are found in a cell. For example, if "MO" or "TU" or "WE" are found. However this function will not support more than one 'OR' in the code. This is the code I tried to use: Selection.AutoFilter Field:=1, Criteria1:="=ALL", Operator:=xlOr, _ Criteria2:="=" & myDay2, Operator:=x1or, Criteria3:="= MT" Is this how this Autofilter is setup to work (only one 'OR') or is my code wrong? Any assistance would be greatly appreciated. Thanks, GLT. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto filter custom filter | Excel Worksheet Functions | |||
Custom filter | Excel Discussion (Misc queries) | |||
Custom Filter Pop-up Box | Excel Worksheet Functions | |||
Custom Filter | New Users to Excel | |||
Custom Filter | Excel Discussion (Misc queries) |