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.

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.

--
Regards,
Tom Ogilvy


"GLT" wrote in message
...
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.

Also,

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

somethinglikeant

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

--
Regards,
Tom Ogilvy


"somethinglikeant" wrote in message
oups.com...
Also,

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

somethinglikeant

Apologies Tom

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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"GLT" wrote in message
...
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.