| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
For next doesn't loop
Thanks everyone, am I a dumb-ass or what? :)
On 29 May, 17:28, Joel wrote: You should increment a loop count yourself like i. *Let the for do it for you * For i = 0 to 9 step 2 * * BuildChkSum = Mid(1234567899, i + 1, 1) * 10 - i * * ChkSum = ChkSum + BuildChkSum * Next i " wrote: Hi guys, At the end of a long, hard day slaving over a keyboard I'm befuddled by something that should be easy (or so I thought). For some reason the for next in the following doesn't loop!?! Sub Test() Dim i, BuildChkSum, ChkSum As Integer * For i = 0 To i = 9 * * BuildChkSum = Mid(1234567899, i + 1, 1) * 10 - i * * ChkSum = ChkSum + BuildChkSum * * i = i + 1 * Next i Debug.Print i Debug.Print ChkSum End Sub i comes out as 2 in the debug statement when I hoped it would be 9 - seeing as it's not looping shouldn't it be 1? Any ideas? Cheers, JF- Hide quoted text - - Show quoted text - |
| 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 | |||
| Naming Worksheets - Loop within a loop issue | Excel Programming | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Threaded Mode
