I use a macro to turn an automatically created report (awful) into something more usable. I compute the sum and the average of each column that is created. As this report is always of different lengths I am unsure how to tell the formula what the last cell is in the range. I want to do something like this...

j = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
ActiveCell.FormulaR1C1 = "=SUM(&j:R[-2]C)"

so basically... I want to sum A1 -> whatever j is

thanks for the help!