vba autofilter across multiple columns

[cjcass]

Hi,
I have the simple code below that filters rows where both criteria are met in the same row.
Is it possible to change it so that it filters all the rows that meet either of the criteria, so not "1" AND "2" but "1" OR "2".
Hope that makes sense.
Any help much appreciated, thanks.

Sheet3.Range("A3").AutoFilter Field:=94, Criteria1:="1"
Sheet3.Range("A3").AutoFilter Field:=95, Criteria1:="2"

 

[Artik]

Use the Advanced Filter, not the Autofilter.

Artik