Filter not working for second criteria

Hi Again!

I wrote a filter in VBA for three columns in my spreadsheet but for some reason it refuses to ignore the second condition of the last filter to exclude the zero values. I'm kind of scratching my head as to why this is so.

The first filter looks for blanks
The second filter looks for "Result"
The third filter gets rid of blanks and zeroes

As always....thanks a million for the support...

.AutoFilterMode = False
Rows("24:24").Select
Selection.AutoFilter
ActiveSheet.Range("$A$24:$AS$16027").AutoFilter Field:=7, Criteria1:="="
ActiveSheet.Range("$A$24:$AS$16027").AutoFilter Field:=3, Criteria1:= _
"Result"
ActiveSheet.Range("$A$24:$AS$16027").AutoFilter Field:=39, Criteria1:="<>", Operator:=xlFilterValues, Criteria2:="<>0"

Re: Filter not working for second criteria

Thanks guys...I realized that my operator was wrong and also that I can only filter for max two criteria per column without a helper column.

Cheers for the quick responses...