I tried that but I kept getting the message that my
search string could not be found (original value of cell)


-----Original Message-----
Have you tried Search & Replace for the text of the
formula?

"Tamesh" wrote in message
...
With the data I have, there isn't always going to be a
value to divide by hence the #div/0! error. If I use
the
if(iserror(),"",()) method, I'd have to re-input the
formula for every cell that does calculations. The
data
is collected from a workbook that is multipaged with
named tabs thus making it a bit tedious to use the
formula in every cell (long tab names). Is there a way
to use a macro or something of that nature to fix this
issue on a large scale rather than one by one?




.