hi
the formula is the microsoft way of dealing with the problem.
see this site.
http://support.microsoft.com/kb/182188
i know of no macro command that would make the #DEV/0! error go away other
than to replace the formula with zero or replace the formula with the above
formula.
regards
FSt1
"Rohit" wrote:
hi, i have various worksheets and within that worksheet there are cells
having #DIV/0!. I want this to be replace by zero. i know there is a
formula which will give out zero but if someone can write a macro would good.
Thanks