Hi,

I am trying to run a macro replacing a part of a formula using find-replace:

Find: AND(
Replace: AND(INDIRECT(“AL”&ROW())="1");

(within the macro of course quotation marks are added)

When recording the macro this works perfectly fine, which is unfortunately not the case when I want to apply the macro in another file.

Thanks a lot in advance if you have any advice on this!
Lucie

----------------------------------------------------