VBA to amend a range of Formulas

Hi,

This may not be in the right section but it covered VBA and Functions so please correct if wrong.

Please see the attached spreadsheet, what i need to is to add an IFERROR argument to every formula that is showing the #REF! so it actually shows blank if the criteria is not met.

However as you will see each formula has a difference reference so i cannot just a CTRL F, Replace All. And i also cannot do a CTRL F, Replace All for part of the formula, ie Replace =IF with =IFERROR(IF but because at the very end i also need to add the ,"") for the iferror argument, CTRL F wont work.

I tried playing around with VBA which i think will work best, i tried the Find =IF and Replace with =IFERROR(IF argument followed by another argument to say insert at the end of cell ,"") but my VBA skills are not quite that advanced.

Can anyone help.

Thanks

Hi,
try it

Please Login or Register  to view this content.

Perfect, thank you very much