Macro find replace in formula

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

Hello Lucie,

To be on the safe side, why don't you attach your Excel file ....

Cheers

Hello!

Sorry for replying late! Please find an example file attached here. I hope it is usable, else I will try to modify it.

Thanks a lot in advance!

Hello,

Your workbook does not seem to be in line wih your initial question ...

Indeed, there is no macro ... and could not find a formula using Indirect() ....