Macros and Array Formulas

How can you use a macro to replace text in an array formula.

I tried the find and replace macro from the wiki and it left only the result in the field not the correct formula

Thanks,

Dennis