Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
if formula question | Excel Discussion (Misc queries) | |||
formula question | Excel Worksheet Functions | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula question | Excel Discussion (Misc queries) |