Set a variable on a FormulaR1C1

Asked Oct 15 '19 at 20:13

Active Oct 16 '19 at 00:05

Viewed 134 times

I'm trying to code a variable R1C1 formula but I don't know what I'm doing wrong. I searched a lot but couldn't find any answer applicable to my case.

Sub Step17()
Dim Final As Integer

ActiveCell.FormulaR1C1 = "=SUM(R[4]C:R[&Final&]C)"

End Sub

I created the variable "Final" because what I need to do is a sum of a range where the last row is going to be different every time so it goes from row 4 to row 50 in the first batch but in the following batch it might end up in row 200.

Thanks so much for your help.

edited Oct 16 '19 at 00:05

Marvin

13,325
3
51
57

asked Oct 15 '19 at 20:13

Daniel Jaramillo

3

`"=SUM(R[4]C:R[" & Final & "]C)"` – Scott Craner Oct 15 '19 at 20:14
That everything I needed! thanks so much for your help. – Daniel Jaramillo Oct 15 '19 at 20:20
1

@ScottCraner Please add this as an answer so it can be accepted and this question doesn't come up as unanswered. – Keith Stein Oct 16 '19 at 02:43

Set a variable on a FormulaR1C1

0 Answers0