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.