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
|