Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a VBA construct like this one
dim SCell as Range for each SCell in Selection.Cells {snip} next SCell .... where the selected cells are 1 column wide and several rows deep. As the For... Next spins through the cells in the selected range, I need to take some actions if the sum of a range of cells on a given row is greater than zero. So, if SCell is at cell B15, I need to find out the sum of cells D15:G15. What is the code to derive that sum? I'm thinking it's some use of OFFSET, perhaps, but I'm not sure of the syntax. Any ideas? Thanks, Dave O |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula based on continuous relative cells | Excel Discussion (Misc queries) | |||
Excel Formula using relative position of cells in two different worksheets | Excel Discussion (Misc queries) | |||
Excel Formula using relative position of cells in two different worksheets | Excel Worksheet Functions | |||
Excel Formula using relative position of cells in two different worksheets | Excel Programming | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions |