Re: Modify Macro to copy formula to new range and update cell references
Thanks for the reply S O,
The code almost works. In the sense that the first row where the code is copied now takes A2=AA2+AB2 BUT the increment in next rows is in Twos..
So that when I run the above code, A2=AA2+AB2 (which is correct and as required) ... but A3 is now =AA4+AB4, A4 is now =AA6+AB6
Am attaching a sample workbook with the data and code in it.
Can you please take a look and advise.
PS: My request was not a typo. I want to copy the formula in Row 10 (A10:D:10) to rows 2 to 9 i.e. to the range A2:D:9 just as would happen when one would select cells A10:D10 and drag them up or down (your code understands my requirement exactly).