Try withOn 2002-02-19 05:53, MJA wrote:
Hello,
I want to total different columns.
But I can't figure out the right code.
For b = 1 To 15
Cells(b, 16).FormulaR1C1 = "=SUM(C & b)"
Next
This doesn't work.
Who can help me!?
Martin
Cells(b, 16).FormulaR1C1 = "=SUM(C" & b
But, why use SUM ? that's only one cell, you could just use:
Cells(b, 16).FormulaR1C1 = "=C" & b
Like this thread? Share it with others