AutoFilter: Criteria1:="0"

[Maurizio]

I must filter a colums with value "0" (zero)but I don't know his format and so I always must input format's column else my code don't run!

My code:
Selection.AutoFilter Field:=1 Criteria1:="0"

runs OK if NumberFormat is = "#,##0 ;[Red]-#,##0 "

but if (my case) is format "#,##0.00_ ;[Red]-#,##0.00 "
don't run?

Why?

 

[Andrew Poulsom]

Won't it work if you leave out the quotes around 0?

 

[Maurizio]

Also if I leave out the quotes around 0 unfortunately don't ok.

 

[Tamer Baþkan]

your code change it
Selection.AutoFilter Field:=1, Criteria1:="0,00"