Modifying cell references
I never said that you should put in the search and replace boxes what is
*after* the parenthesis of getValue(
Try simply with:
Find What: *!getValue(
Replace with: =getValue(
If you want to do it with a program, simply record a macro when you do the
Search And Replace operation, then look at the code and eventually adapt the
range and run it whenever you want.
|