I have over 720 functions across four worksheets that commonly results
in #Div/0 errors. I want to insert an "error handling" function to
make those #Div/0 errors disappear. That's the easy part. I am
using:
=IF(ISERROR(OriginalFormula),"",OriginalFormula)
-- "Original Function" could be as simple as: =((A1+A5)/(B1-B8))
My problem is that I don't want to manually go to each cell and cut,
paste, cut, paste, etc. to make the alterations to each formula.
Is there any macro that will make each "OriginalFormula" a variable,
and automatically paste the variable (original function) back into my
desired new function above?
Thanks....
--
bmstar
------------------------------------------------------------------------
bmstar's Profile:
http://www.excelforum.com/member.php...o&userid=36264
View this thread:
http://www.excelforum.com/showthread...hreadid=565888