I want to sum a column of numbers in an Excel spreadsheet using VBA. Is there a way of doing it in a macro without using a For...Next loop. Like writing Range("A1.A10") and adding some operator? Or is there a way of accessing the Excel SUM function in VBA and using that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Summing a range of numbers in Excel with VBA
- Thread starter yalamo
- Start date
- Status
Similar threads
- Locked
- Question
