If those cells are blank, the "-" is a "0"... check to see if you have it set
to show zero values....

"Chuck Neal" wrote:

I have the following formula in cell D1.

=IF(A1=C1,B1," ")

It is possible that cells A1 and C1 could be blank. When that happens, the
formula returns a "-" in D1. Normally I would use the Autofilter and delete
these, however, I am using a macro and using the Autofilter slows it down to
a crawl. Is there a way (formula or otherwise), to eliminate the - in my
cell?
Thanks!