Cecil, exactly what does the code you just gave me do?
Thx for the help.
-----Original Message-----
Tamesh,
if #div/0! error is in a cell with formulas use
Range("A1").Select
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
Selection.ClearContents

if you have done copy and paste special values then
Range("A1").Select
Selection.SpecialCells(xlCellTypeConstants,
16).Select
Selection.ClearContents
HTH
Cecil

"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?




.