Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I hate having to ask this 101 question, but here it goes: I have the following code in a function: c1 = Array(1, 2, 3) c2 = Array(100, 200, 300) r1 = 6 r2 = 600 For n = 1 To 2 If r? < Application.WorksheetFunction.Sum(c?) Then ... do this ... Else ... do that ... End If Next n I want to pass the value for r1 and c1 to the expression in the If statement the first time through the loop (n=1), and the value for r2 and c2 to the expression the second time through the loop (n=2), etc, but I cannot figure out the syntax to replace r? and c? with. thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
simple loop needed please | Excel Discussion (Misc queries) | |||
Loop with variable name? | Excel Discussion (Misc queries) | |||
I need a simple loop with a 4+ row added in. | Excel Discussion (Misc queries) | |||
Insert Variable Number of Rows; With Loop | Excel Worksheet Functions | |||
Loop Macro a variable number of times | Excel Discussion (Misc queries) |