Totaling a Range of Data

[dak413]

I am a beginner user to Visual Basic and am having trouble obtaining a total for a range of data in a single column where the number of rows will changes each time the macro is run? The only formula I can find is for a fixed range:

ActiveCell.FormulaR1C1 = "=SUM(R[-19]C:R[-1]C)"

What would be the alternative to this so that it doesn't have a fixed range to total?

 

[PHV]

Have a look in the FAQ area: at least two ways to retrieve the last used row of a range.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886