Rather than a blanket trap for all errors, which might hide a real problem,
better to look for divide by zero specifically.

So if your formula is =A1/B1, change it to
=IF(B1=0,"",A1/B1)
--
David Biddulph

"xlm" wrote in message
...
try using this

=IF(ISERROR(Your formula),"",Your formula)

or

=IF(ISERR(Your formula),"",Your formula)

to place a 0 instead of blank, change "" to 0

HTH
--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis









"wanttolearn" wrote:

I'd like to replace #DIV/0!
with a blank or a 0 in the cells that have this after I copy a formula to
a
range of cells. Replace doesn't recognize the symbol.