Hi all,

Using Excel 2010.

I need 2 filter a Range to remove 2 values in the Range: "-" (Accounting zero format) and 00 (left justified as text)

I receive an AutoFilter Method Of Range Class Failed error message here:
        rngFilter.AutoFilter _
                    Field:=2, _
                    Criteria1:=Array("<>-", "<>00"), _
                    Operator:=xlFilterValues
The Range definitely exists. Any other thoughts?

thx
w