Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range
I would like to sum up some values within the cells for each loop,like A1..A5
when i = 1, B2..B6 when i=2 etc., I know I can not put the cell variable into the Range() property. Are there any other way to do this? Please help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range
If I understand you correctly:
For i = 1 to n mySum = Application.Sum(Cells(i, i).Resize(5, 1)) 'other stuff Next i In article , "Gian" wrote: I would like to sum up some values within the cells for each loop,like A1..A5 when i = 1, B2..B6 when i=2 etc., I know I can not put the cell variable into the Range() property. Are there any other way to do this? Please help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range
Thanks JE.
"JE McGimpsey" wrote: If I understand you correctly: For i = 1 to n mySum = Application.Sum(Cells(i, i).Resize(5, 1)) 'other stuff Next i In article , "Gian" wrote: I would like to sum up some values within the cells for each loop,like A1..A5 when i = 1, B2..B6 when i=2 etc., I know I can not put the cell variable into the Range() property. Are there any other way to do this? Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range | Charts and Charting in Excel | |||
Dynamic Range | Setting up and Configuration of Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
Sum Up Dynamic Range | Excel Programming |