vba autofilter multiple criteria same column not working

[cizzett]

So I am trying to use this to exclude two different choices in column 4 but it does not want to work, Any advice?

.AutoFilter 4, "<>ETOX-SKIP, EDC/WDC", xlOr, "<>EDC/WDC"

Of course this is just a snipit of the code but the part that does not seem to work, if i make it a single criteria it works perfect but i would like to exclude both.

Any help is greatly appreciated.

 

[Fluff]

Change xlOr to xlAnd

 

[cizzett]

Yeah it works now, I tried that that before I posted, I must have fat fingered something the first time....

Thanks as always.

 

[Fluff]

You're welcome & thanks for the feedback