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

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

Hi Brendan,

Thanks for your fast reply. Please find below an essential part of the macro. (I only show this part of the macro as it is basically repeated a couple of times with slight adaptations).

Please Login or Register  to view this content.

Thanks a lot in advance!
Lucie

Actually it is important to have the macro applied only to this specific sheet and range (because 'AND(' exists in other formulas where I don't want to have it replaced). Is that doable?

Thanks a lot for the modified code! I tried it and it worked to a certain degree: it works if I simply write the to be replaced text into a cell, but the macro apparently does not access the formula itself and hence does not recognize what to replace within formulas. I have also tried switching the automatic recalculation of formulas to the manual mode and also tried the option of showing formulas, none of which helped either. Is there something else one could try?
Many thanks again!

Please find an example file attached here. I hope it is usable, else I will try to modify it. Thanks in advance!

Excellent, that's exactly what I needed! Thank you so much!
All the best,
Lucie