Here’s the file.
find-replace.ods (11.9 KB)
I want to change the formulas from <500 to <400, I’m not getting errors but it doesn’t change the formula when I try to change it. Is there a way to do this correctly?
Read the online HELP for topic “Editing Array Formulae”
special key presses are required but it will work if you follow the instructions
it uses ctrl-/ and ctrl-shift-enter
regards
that only work on a single selection of array formula, it doesn’t work on multiple selection of array formulas or when I use find & replace (ctrl+h)
1 Like
Is there a reason why you don’t put your variable in a separate cell?
Not really 
Is there other way?
Whether you try it in interactive mode (Ctrl+drag) or by F&R:
For multi-range selections you only can change cell attributes/styles, but not the content.
The only exception: DEL.
You might use F&R only for finding the wanted multi-range selection, and then run user code. This code would need to treat the selection one range after the other then.
... < MyParam.$A$1
see Recognizing Names as Addressing,
Addresses and References, Absolute and Relative