I'm tring to auto sum a column that will change in lenght from sheet to sheet. I'm writing a macro to do this for people that really don't understand how to calculate metrics. Any idea's on how to make this work?

ActiveCell.SpecialCells(xlLastCell).Select
ActiveCell.Offset(3, -2).Select
ActiveCell.FormulaR1C1 = "Total Points"
ActiveCell.Offset(1, 0).FormulaR1C1 = "Total Missed"
ActiveCell.Offset(2, 0).FormulaR1C1 = "Subtotal"
ActiveCell.Offset(3, 0).FormulaR1C1 = "Points Taken"
ActiveCell.Offset(4, 0).FormulaR1C1 = "Delta"
ActiveCell.Offset(-2, 0).Select
ActiveCell.FormulaR1C1 = "=SUM"
ActiveCell.Offset(0, 1) = "=SUM" <-Column "K"
ActiveCell.Offset(0, 1) = "=SUM" <-Column "L"
ActiveCell.Offset(0, 1) = "=SUM" <-Column "M"

Remember that the K column will not always be the same number, so how do I select "K1" and then the last value of K column?