formula question
 

I would like to try summing all of the rows of data at the
end of the transactions. I tried the formula below but I
get an error.

The problem is that the last row will always be different,
so I want to set a variable to identify that row.

ActiveCell.FormulaR1C1 = "=SUM(R[lastrow1]C:R[-2]C)"

Any help would be greatly appreicated. Thanks

formula question
 

Hi
try:
ActiveCell.FormulaR1C1 = "=SUM(R[" & lastrow1 & "]C:R[-2]C)"

--
Regards
Frank Kabel
Frankfurt, Germany
"JT" schrieb im Newsbeitrag
...
I would like to try summing all of the rows of data at the
end of the transactions. I tried the formula below but I
get an error.

The problem is that the last row will always be different,
so I want to set a variable to identify that row.

ActiveCell.FormulaR1C1 = "=SUM(R[lastrow1]C:R[-2]C)"

Any help would be greatly appreicated. Thanks