Hello,
I am trying to program a code with FormulaR1C1, referencing to cell that would be moved when I scale down the formula.
In cells
C2 and
D2, I am having data, added in variables
row and
cell. in variable
C6, I am having FormulaR1C1 with variables
row and
cell (including data from
C2 and
D2).
In
C6, I have formula referencing to cell
A4, when I want to scale down cell
C6 -> C7 - > C8 with this formula, I would like to scale down also the referenced cell
A4 -> A5 -> A6.
- cell C6 refers to A4
- cell C7 refers to A5
- cell C8 refers to cell A6
The problem is that the cell is always fixed in the same row, where formula is, so cell C6 refers to A6, cell C7 refers to A7 etc.
My code:
Code:
Sub MakroTest1()
row = D2
coll = [C2]
Worksheets("List1").Range("C6").FormulaR1C1 = "=R" & row & "C" & coll & ""
End Sub
Would you have any suggestion how to move referenced cell with this formulaR1C1? I have attached the excel file and print screen.
I am really lost. Thank you
Filip