Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum only certain figures in the column | Excel Discussion (Misc queries) | |||
Calculate Figures in a column if ajacent column has particular da | Charts and Charting in Excel | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
How to convert FIGURES in one column to WORDS in another column? | Excel Discussion (Misc queries) | |||
Formula or UDF to add figures by code # | Excel Discussion (Misc queries) |