hi!

i would like to do find and replace formula in a range of cells.
eg:
original formula is:
='sheet1'!$a$1
i would like to have it replaced with:
=SUM('sheet1'!$a$1:$d$1)

i only managed to do the first part where i replaced the original formula with this:
=SUM('sheet1'!$a$1)
but i cannot anymore continue with the range to col d.

i need to replace only the column reference in the formula and not the row because it will be done on several cells with different row references. (say from row 1 to 100)

i hope i managed to explain the problem well.
thank you in advance for any help i could get for this.