Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating For Loop statements
Hi,
I have a For Loop in a VBA macro, for example: b = 2 c = 26 For i = 1 To 10 For a = b To c Print something in Excel using "a" (this bit is not important) b = b + 25 c = c + 25 Next Next So that once the For Loop is complete the limits are updated for the next time inner For Loop is used. However, I find this when the inner For Loop is used for the second time "b" and "c" are reset to the values 2 and 26. How can I get this to work? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating For Loop statements
Hi Stuart,
You're updating the variables in the wrong place. Try it like this: b = 2 c = 26 For i = 1 To 10 For a = b To c Print something in Excel using "a" (this bit is not important) Next b = b + 25 c = c + 25 Next -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "stuart" wrote in message ... Hi, I have a For Loop in a VBA macro, for example: b = 2 c = 26 For i = 1 To 10 For a = b To c Print something in Excel using "a" (this bit is not important) b = b + 25 c = c + 25 Next Next So that once the For Loop is complete the limits are updated for the next time inner For Loop is used. However, I find this when the inner For Loop is used for the second time "b" and "c" are reset to the values 2 and 26. How can I get this to work? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) | Excel Worksheet Functions | |||
Need loop structure to get round limited IF statements | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions | |||
Worksheet_Change - loop within a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |