View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lecaballero lecaballero is offline
external usenet poster
 
Posts: 5
Default Replace formula with IF(error(formula;"";formula)


Hi all

Do you think is there any macro that can change the formula in selected
range to include the IF-iserror so no error appears on the screen?

For example:
In cell A1 the formula is: =A2+B2
But if I select A1 and run the macro, It would change to:
=IF(ISERROR(A2+B2);"";(A2+B2))

I need that beacause I have a sheet with lots of formulas with different
errors and It would be quite painful to chang every formula.

Thanks you for your help!!!!