Excel VBA - Unchecking a text filter

I'm trying to write a script to开发者_运维技巧 apply a filter to a particular column in excel, and then uncheck one of the text filters. Can anyone help?

Thanks, Dan

You can use the macro vba recorder to build a sample version of what you're trying to do and then adapt the code.

You can also have a look here.

Rather than unchecking a filter you need specify all the ones you do want eg

ActiveSheet.Range("$B$1:$D$21").AutoFilter Field:=3, Criteria1:=Array("1", _
    "12", "2", "22", "4", "5", "6", "8"), Operator:=xlFilterValues