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?

 

[ChewDoggie]

are you sure this is a visual basic problem? Sounds a lot like you're talking about an excel spreadsheet. I'm not familiar with the use of "macros" in VB.


Many Thanks!

AMACycle

American Motorcyclist Association

http://www.ama-cycle.org

 

[SkipVought]

dak413,

Please post this in the VBA Visual Basic for Applications (Microsoft) forum707.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}

 

[dak413]

I will post it in that forum. Thanks.