code to add formulas to a range with previous formulas appearing inside the new one

I often come across a situation where I want to add a formula to a range (let’s say an extra restriction, like an ‘IF’ formula), but since the range has many other formulas, I have to basically go 1 by 1 changing the range (cell by cell, column by column or row by row).


Is there a code to add formulas to a range so the previous formulas appear inside the new added formula?


If not, can someone help me creating a macro for the same?


Of course this has some limitations and considerations that must be taken into account:



· The new formula should be dynamic and obey to the ‘$’ restrictions (e.g. $A$1 means the cell is fixed, $A1 means the column is fixed, but the row is mobile, etc).

· Formulas can have 1 extra parameter or several extra parameters (e.g. Vlookup has 3 new parameters, the reference table, the column number and the “False” parameter, whereas left has only 1 extra field).

· In case the range to modify contains an array, then it would be useful if it keeps it that way.


Thanks in advance.

Regards,
Excelorator

Thanks for the advise Pike. However, I cannot use Find/Replace as I have different formulas in the whole range. So using Find/Replace is as good as going to each cell in the range and changing the formula.

I think you need to give us specific details of what needs doing. I don't think one could write code to cater for changes to any formula at all.