Summing a column in excel using vb

[mcornbill]

Hi all

Simple one for you. I want to sum a column of data I have in excel using vb. The data can be different amounts of length in rows and the I will always have the sum 2 cells underneath the last entry of data.

Cheers
Mark

 

[jindon]

Hi

Range("a" & Rows.Count).End(xlUp).Offset(2).formulaR1C1= _
"=sum(r1c:r[-1]c)"

 

[mcornbill]

Thanks a lot Jindon

I am forever struggling with range commands!