Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For To / Next loop doesn't update...
How come this sub only runs through i=1 and i=2, when k is obviously
updated during loop? Sub Test() k = 2 For i = 1 To k Debug.Print k If k = 2 Then k = 4 Next i End Sub I know this sub solves the problem, but I find Do While loops to be clumsy - any other solutions? Sub test2() k = 2 i = 1 Do While i <= k Debug.Print k If k = 2 Then k = 4 i = i + 1 Loop End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For To / Next loop doesn't update...
Better examples - but same result :)
Sub Test() k = 4 For i = 1 To k Debug.Print "k = " & k & " i = " & i If i = 2 Then k = 8 Next i End Sub Sub test2() k = 2 i = 1 Do While i <= k Debug.Print "k = " & k & " i = " & i If k = 2 Then k = 4 i = i + 1 Loop End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
For To / Next loop doesn't update...
Because the loop limit is set when it executes the For statement, it does
not get updated just because the variable that initially set it gets changed. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TFriis" wrote in message ... How come this sub only runs through i=1 and i=2, when k is obviously updated during loop? Sub Test() k = 2 For i = 1 To k Debug.Print k If k = 2 Then k = 4 Next i End Sub I know this sub solves the problem, but I find Do While loops to be clumsy - any other solutions? Sub test2() k = 2 i = 1 Do While i <= k Debug.Print k If k = 2 Then k = 4 i = i + 1 Loop End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
update range in For loop | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |