Updating For Loop statements

[Guest]

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.

 

[Rob Bovey]

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 *

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.