VB code to sum up all the figures in a column
 

Hello all, need your help to solve my problem. You see, I have a sourc
file which consists of Names, figures. I am writing a VB code or set
macro to calculate the total sum of the figure column, my problem is
managed to sum up the figures but sometimes the source file migh
consists of many records, so how do I solve this problem by taking int
account that it will calculate all the figures in that column
Appreciate ur help

--
Message posted from http://www.ExcelForum.com

VB code to sum up all the figures in a column
 

Let's say the numbers are in column D.

Total = Application.Sum(ActiveSheet.Columns(4))

or

Total = Application.Sum(Intersect(ActiveSheet.UsedRange,
ActiveSheet.Columns(4)))

On Thu, 5 Aug 2004 12:56:25 -0500, tanks1308
wrote:

Hello all, need your help to solve my problem. You see, I have a source
file which consists of Names, figures. I am writing a VB code or set a
macro to calculate the total sum of the figure column, my problem is i
managed to sum up the figures but sometimes the source file might
consists of many records, so how do I solve this problem by taking into
account that it will calculate all the figures in that column.
Appreciate ur help.


---
Message posted from http://www.ExcelForum.com/