if cell is wrapped with IFERROR function, then delete the function from the cell

Hi!
I need a macro that would delete the IFERROR() from each cell that contains it...
In other words: if the cell is now e.g. "=IFERROR(x,y)" the macro should make it "=x".

Do you have any idea how to do it?
Please help!
Kris

"Find and replace" is not able to do what i need. I need the following:

IF the cell contains =iferror('here is some other function X with variables' ; 0) THEN
make the cell contain only ='the function X'.

Any ideas please?

Ok, so this is what I meant (see below code) more or less.
The problem is that the code works fine if there is only 1 digit (the zero) after the coma: =IFERROR('sth',0)
If there were more digits (eg. two zeros) then I am in trouble again.
Any ideas pls?

Please Login or Register  to view this content.

find and replace? how? i am not that familiar with the functions... could you explain more or propose some vba code?

what I need is that the macro works the similarly as my macro i posted above, just with the difference that my macro does not automatically adjusts if there are more than one digit after the coma (see my above post).

This macro should do what you need, providing it only ever encounters IFERROR wrapping other formula and never within a formula.

Please Login or Register  to view this content.