Hello again,
I have three columns(A, B, C) there is a serie of numbers in each column. I want the total of each column in cells D1, D2 and D3.
Sub Test()
For x = 1 To 3
Cells(x, 4).FormulaR1C1 = "=SUM(C" & x & ")"
Next
End Sub
The macro above can't do the trick.
WHY?!?!
Best regards,
Martin
I have three columns(A, B, C) there is a serie of numbers in each column. I want the total of each column in cells D1, D2 and D3.
Sub Test()
For x = 1 To 3
Cells(x, 4).FormulaR1C1 = "=SUM(C" & x & ")"
Next
End Sub
The macro above can't do the trick.
WHY?!?!
Best regards,
Martin