Autofilter Method Query - Criteria1: <> Not Equal

[Orson100]

Hi,

This is probably a case of my not knowing the correct syntax (I do not have any programming background) but I have a problem as follows.

I have a table which I need to filter twice:

in the first instance, filtering by each row where the selected field (=2) is equal to any of a group of named strings (IncludedFamily1 etc),

and in the second instance, filtering by each row where the selected field (=4) value is not equal to any of a group of named strings(ExcludedComponent1 etc)

Here are the 2 statements:

Please Login or Register  to view this content.

The first statement works fine.

The second statement does not, returning either an error message during code exec or else not filtering the table as intended, depending on the use and/or placement of the various "not equal to", "<>", "NOT" variations of code that I have tried to date.

I hope this makes sense. Any pointers towards incorporating the required "<>" requirement into the second statement would be greatly appreciated.

Thanx
Orson.

[bryangdrake]

In my experience the <> operator is not compatible with the xlFilterValues operator.

You will have to use the xlAnd Operator to accomplish this.

ActiveSheet.ListObjects("MasterPriceList").Range.Autofilter(2, "<>" & ExcludedComponent1,xlAnd, "<>" & ExcludedComponent2)