Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I need to know the sum of a group of cells I us this piece of code to do this job dTotal = 0 iRowCounter1 = 2 iColumnCounter1 = 5 Do Until Sheets("Futures").Cells(iRowCounter1, iColumnCounter1).Value = "" Do Until Sheets("Futures").Cells(iRowCounter1, iColumnCounter1).Value = "" dTotal = dTotal + Sheets("Futures").Cells(iRowCounter1, iColumnCounter1).Value iRowCounter1 = iRowCounter1 + 1 Loop iRowCounter1 = 2 iColumnCounter1 = iColumnCounter1 + 1 Loop Does any one know how to do this, without looping through all the cells, as it is always the same size Thanks MarkS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match a group of cells with another group of cells | Excel Worksheet Functions | |||
Allow macro to work for a group of cells but not the other cells | Excel Programming | |||
from a group of cells.find average of cells containing values | Excel Discussion (Misc queries) | |||
Adding zero's to a group of cells | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |