If you're trying to put a formula in there, you need the address of the range:
If you just want the value, then:
Sorry, but it doesn't work
The sheet is attached here.
Sorry, I answered to fast.
The second option worked great
this one - (Range("r1").FormulaR1C1 = "=sum(R1C1:R" & Lrow & "C" & Lcol & ")")