Unfortunately this isn't going to work.   I run the risk of replacing all the commas in all the formulas.   I have to consider the fact that the user may have nested formulas, which means that simply running the search & replace again for just those two arguments wouldn't be the end of it.   I'd have to keep scanning for new errors as a result of replacing commas in other parts of all the formulas.   This would also replace commas in standard excel formulas as well.

Thanks for suggesting that addin but without specifying the argument location in the replace, it could potentially do more harm than good.

I've already started writing a two part macro to resolve this:

1.   Locate all GL formulas with errors and copy them on to a new sheet.

2.   After manually modifying all the formulas to reflect the new operator (in the new sheet), run another macro which replaces the GL formulas with the new structure.

FYI, Excel already has the capability of looking in Formulas as oppose to Values and replacing the characters appropriately.   It also has the ability to do this for an entire workbook as oppose to just one sheet.   The only added capabilities that the addin seems to provide is the ability to search multiple workbooks and selectively change whichever cells the user wishes to modify.

Unfortunately this isn't going to work.   I run the risk of replacing all the commas in all the formulas.   I have to consider the fact that the user may have nested formulas, which means that simply running the search & replace again for just those two arguments wouldn't be the end of it.   I'd have to keep scanning for new errors as a result of replacing commas in other parts of all the formulas.   This would also replace commas in standard excel formulas as well.

Thanks for suggesting that addin but without specifying the argument location in the replace, it could potentially do more harm than good.

I've already started writing a two part macro to resolve this:

1.   Locate all GL formulas with errors and copy them on to a new sheet.

2.   After manually modifying all the formulas to reflect the new operator (in the new sheet), run another macro which replaces the GL formulas with the new structure.

FYI, Excel already has the capability of looking in Formulas as oppose to Values and replacing the characters appropriately.   It also has the ability to do this for an entire workbook as oppose to just one sheet.   The only added capabilities that the addin seems to provide is the ability to search multiple workbooks and selectively change whichever cells the user wishes to modify.