VBA Code for an Auto Filter Column that will exclude multiple criteria

[jgome21]

Hi Guys,

I am having trouble coming up with a VBA code that excludes 3 criteria's from an auto-filter. I want to filter out all data that includes the words "Open", "Focus" & "M10" in cells of a column. So far I have the code below, but it isn't working. Any advice would be greatly appreciated. Sorry, I am still new at VBA.

Sheets("Raw data").Select


ActiveSheet.Range("$A$1:$BQ$12290").AutoFilter Field:=6, Criteria1:="HW563001"
ActiveSheet.Range("$A$1:$BQ$12290").AutoFilter Field:=12, Criteria1:=("<>*Open*""<>*Focus*""<>*M10*")

 

[steve the fish]

You cant use an autofilter to do that. Try to do it manually. You will see you can only use two criteria.

 

[Fluff]

Other than the 3 criteria you have listed, how many other values are you likely to have in that column?