How autofilter column with specific text and numeric values?

81 views Asked by At

I have this range, say, A1:H2000, that needs to be filtered in column A - i have two different critera for this filter as following:

criteria 1 - array("C1","C2", "C3")

criteria 2 - numeric value is greater than 0

With activesheet
    .range("A1:H2000").autofilter Field:=1, Criteria1:=Array("C1","C2","C3"), operator:=xlFilterValues
    .range("A1:H2000").autofilter Field:=1, Criteria2:=">0", operator:=xlOr
End with

When i re-prioritise the two lines - the filter only ends up fulfiling one criteria only and never both that is what i need.

Appreciate any advice in advance.

0

There are 0 answers