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?
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?