Edit multiple formulas at once (not find/replace)

I have different formulas in one worksheet and would like to add to all of them IFERROR function. Find/replace wouldn't work as there is nothing to find and replace, but to add :-) Any ideas? Thanks..

Hi Rag,

thanks for answering. I have attached the example of my data structure. Every week i create a new excel sheet with the data update, separate i have a summary sheet with references to these weekly updates. In this summary sheet I would like to have already references for the future weeks (they don't exist yet, but i know their file names). Of course, when i put references to the non-existing excel it shows me an error. However, if i'll add IFERROR function, it will show me just an empty cell and will get updated every time i create a new weekly update and have both files open. As i have a huge amount of data, it would be just stupid work to go to each cell and add IFERROR... Unfortunately, your suggestion didn't work. But thanks for trying to help...

Your file shows only "#REF!".

Yes and no :-) This is how i have it at the moment as only 1st week update file is available. This is exactly my point, that i would like to add IFERROR function to get rid of the "#REF!".

Try this


=IFERROR("Your formula","")

Yes, this is what i would like to add, but at once to all formulas (i have tons of them) :-) Thanks

Pl Mark the thread SOLVED< If you are satisfied.
You can use macro to change all formulas.

Well, actually it's not solved as i still didn't find a solution how to do it (at least, without macro, i am not very good here..). I am sure, it must be a way how to add IFERROR to all formulas at once, but i just don't know it... Could you, please, advice, how to do it with macro? Thanks!

Hi Raga, yes, there are no formulas and they shouldn't be, it's only references, which obviously i can't use in the example sheet. Just let me try to explain again my problem: i have many sheets with different calculations and i have one summary sheet with references to some cells from other sheets. So, no formulas so far... Everything would be just perfect if not my wish to add to every reference an IFERROR function. Why do it need it? Because some of the references are not valid. The point is, that i create every week a new sheet and it has an exact name and I store it in the exact folder, so i know the path. Meaning, that i can create a reference already in the summary sheet and later, when i will create a new week calculation, it will be updated automatically. So, bottom line - i need to find a way how to add an IFERROR function to the selected cells (independent if it's a formula or reference, as it doesn't play a big role in this case) AT ONCE, without going to each cell and add it manually. I hope, it's clear enough:-) Thanks!