Custom Filter using more than two 'OR'

[Guest]

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.

 

[Tom Ogilvy]

Yes, it only supports two criteria.

You will either need to us an advanced filter or put in a dummy column that
has a formula that determines if the row should be visible or not and filter
on that column.

 

[somethinglikeant]

Also,

On this I have found the Database functions to be very useful:-
=DSUM =DSUMIF, etc.

somethinglikeant

 

[Tom Ogilvy]

The advanced filter is the filtering equivalent to the D functions (there is
no DSUMIF I am aware of).

 

[somethinglikeant]

Apologies Tom

 

[Guest]

Hi Tom,

How do I set up an advanced filter in VBA?

I tried to do it via the help and I can't make any sense out of it ...

Chrees