Excluding items from filter

[ij1001]

Hi,

a common VBA problem, I reckon, but I can't find any answers that fit that well.

The problem: I have a filter that has maybe 50 unique values and I want to omit just one of them. Is there a simple way of doing this (I know how to set one or a few in VBA - do I have to use a loop of some kind to set them all and just omit the one I don't want?)

Thanks

[ij1001]

I'm finding the terminology difficult on this one. What I want is a way to switch all filters to allow data through (unfiltered) except for one. There are 50 or more potential filters and I don't want to manually set all of them to checked except for one:

Column A
=======
AAA
BBB
CCC
DDD
EEE
FFF
...
ZZZ

In the example above, using VBA, how can I allow all data to be selected except for, say, CCC without hard coding so after the filter is applied it looks like:

Column A
=======
AAA
BBB
DDD
EEE
FFF
...
ZZZ

Hope this makes sense!

[snb]

Posting a sample workbook would make sense.

Please Login or Register  to view this content.

[ij1001]

Hi,

couldn't get that to work - please see attached sheet. Sheet1 (abc) is unfiltered, Sheet2 (def) has CC filtered out - can you show me how to do this in VBA with that example please?

[ij1001]

Sorted - you're code did work (of course) - thanks