How to Sum Ranges Using Visual Basic for Applications (148317)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
This article was previously published under Q148317 This article also applies to: - Microsoft Excel for Windows 95 7.0|7.0
- Microsoft Excel for Windows 95 7.0a|7.0a
- Microsoft Excel for Windows 5.0|5.0
- Microsoft Excel for Windows 5.0c|5.0c
- Microsoft Excel for the Macintosh 5.0|5.0
- Microsoft Excel for the Macintosh 5.0a|5.0a
SUMMARY
In Microsoft Excel, you can use a Microsoft Visual Basic for Applications
macro to sum or subtract two ranges of data and to then place the result
into a third range without using formulas in the cells. You can do this in
the same workbook or from more than one workbook into a workbook using
defined names.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB148317 |
---|
|