Three Criterias for filtering in excel?

[Cubajz]

Hi I have this macro for updating filtering when changes occur in different sheet. It works great, but I need one more Criteria to be in this macro...Is there a way to add Criteria3? It would be Criteria3:="<>0"



Sub aktualizace_Filtru_xx_o()
Dim x As Variant
Set x = Sheets("skutečný SeznamPřílohDoprava")
x.Range("$A$1:$B$51").AutoFilter Field:=2, Criteria1:="<>*xx*", _
Operator:=xlAnd, Criteria2:="<>o*"

End Sub


Thanks for any advice!

[leelnich]

Hi CubaJz- I have not tested it, but try this:

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee

[Cubajz]

Unfortunately this doesn´t work, writes Method AutoFilter failed.

[leelnich]

Then you'll need to go with AdvancedFilter, which means defining a criteria range on a worksheet. Back in a few...

[xladept]

Try this:

Please Login or Register  to view this content.

[Cubajz]

Hi thanks for your effort I really appreciate it, unfortunatelly for some reason it only applyed one filter - always the last on in Array (from your code above it applyed does not equal "0"