Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop to Next item in For Next on Condition
Is there a way to do the following:
For i = 1 to iEnd If Array(i) = Value Then Next i Else For j = 1 to jEnd .. .. .. Next j End If Next i I know I can't have the Next i in there twice. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop to Next item in For Next on Condition
For i=1 to iEnd
If Array(i) = abc then goto 1 ... Else For j=1 to jEnd ... Next j End if 1: Next i Bob Umlas Excel MVP " wrote in message ... Is there a way to do the following: For i = 1 to iEnd If Array(i) = Value Then Next i Else For j = 1 to jEnd . . . Next j End If Next i I know I can't have the Next i in there twice. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop to Next item in For Next on Condition
i = lbound(array)
do while i <= ubound(array) if array(i) = array1(kk) then j = i do while array() = array1(kk) j = j + 1 loop msgbox "for value " & array1(kk) & vbnewline & _ "Start position is " & i & vbNewline "End position is " & j exit do Loop -- Regards, Tom Ogilvy " wrote in message ... Is there a way to do the following: For i = 1 to iEnd If Array(i) = Value Then Next i Else For j = 1 to jEnd . . . Next j End If Next i I know I can't have the Next i in there twice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop Until non-incrementing cell condition met. | Excel Worksheet Functions | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Loop until a condition is False | Excel Programming | |||
two-condition loop | Excel Programming |