I have a worksheet in Excel. In column B I have merged cells in pairs of 3. It starts with 3to5 then 6to8 and so on.
In these cells there are formulas referring to a worksheet called "Begroting Calc Won". The formulas are:
=ROW('Begroting Calc Won'!K11) in cells 3to5
=ROW('Begroting Calc Won'!K12) in cells 6to8
and so on.
I have a lot of these merged cells with formulas and tried to write a macro to change the worksheet to which it refers from "Begroting Calc Won" to "Begroting Calc Uti".
My code is below, but it won't work. The part with "i + j" is wrong I think.
Can someone solve this problem? Thanks in advance!