VBA code for filters

[EdE]

I am trying to filter a column to show all values except 0.

This line gets me 0:
ActiveSheet.Range("$A1:$AG$79").AutoFilter Field:=1, Criteria1:="0"

But when I change the = to <> I get a "Expected: Named Parameter" error.

How can I change to show all data but 0?
Thanks!

 

[Scott R]

This worked for me:

Criteria1:="<>0"

 

[ISY]

Hallo

ActiveSheet.Range("$A1:$AG$79").AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd