Hey

I have the following code that was recorded through the Macro record function. The goal was to exclude the cells that had the word "PRE" in it. At the time I recorded the Macro there was only a few things in the list other than "PRE". If someone adds a value not in the code and the Macro is run, the new value is also excluded from the filtered list.

How can I filter $A$1:$P$25001 to exclude only values of "PRE" contained in E:E ?

Here is the code from the Macro

    ActiveSheet.Range("$A$1:$P$25001").AutoFilter Field:=5, Criteria1:=Array( _
        "?", "??", "???", "Complete", "FC", "N/A", "POST", "="), Operator:=xlFilterValues