Total the last cell in a column

[smazza]

How do I make the last cell in a column whose range floats? For instance one time I may have 15 cells that I need totaled in a column & the next time I may have 25. Whatever the last cell in the column after the last filled in cell, I want it to total those cells.

 

[GTO]

I am not sure this is what you want, but if you are wanting to do it "manually", you can name a range of cells in the column and in a cell wherever:

=SUM(MyRangeName)

If you insert rows in the middle of the range for more numbers, these become part of the named range.

 

[Trevor G]

What about something like this

Sub Macro1()
Dim myRange As Range
Set myRange = Range("C2:c500")
Range("C2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = Application.WorksheetFunction.Sum(myRange)


End Sub