SUM Column

[The_Rock]

Hi Folks
I want to put in a formula in C6 to sum all the data from B10 down to the last row of data. Column B will always start from B10 but has variable data.

I tried the following but that only added two rows.
Range("C6").FormulaR1C1 = "=SUM(R10C:R[5]C[-1])"


The following is a compile error. Can this be modified in anyway?

Range("C6").FormulaR1C1 "=Sum(Range("B10:B" & Range("B" & Rows.Count).End(xlUp).Row))"

Cheers

 

[VoG]

Try

Range("C6").Formula = "=Sum(B10:B" & Range("B" & Rows.Count).End(xlUp).Row & ")"

 

[The_Rock]

Brilliant, just what I needed.

Many Thanks