How to Advance a For Next Loop prior to the Next Statement
 

I have a For Next Loop. I want to publically define a variable that updates
in another module that increments (1,2,3,4,5 etc). In the loop below I want
to be able to test this public variable to see if it has reached a defined
limit (say 35,0000). When it does, I want to be able to increment the loop
to the next X value. I know I can Exit the loop with "Exit For". But how do
I increment it (i.e. what Next would do) based on my IF value being true
without running the code under the IF statement?

For X = 1 to 10
If PublicVariableCounter = 30,000 Then [increment X to next value]
Call other modules
Next


Thanks

How to Advance a For Next Loop prior to the Next Statement
 

Hi ExcelMonkey,

Maybe I'm misunderstanding your question, but can't you do something like
this:

For X = 1 to 10
If PublicVariableCounter < 30,000 Then
'Call other modules
End If
Next

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


ExcelMonkey wrote:
I have a For Next Loop. I want to publically define a variable that
updates in another module that increments (1,2,3,4,5 etc). In the
loop below I want to be able to test this public variable to see if
it has reached a defined limit (say 35,0000). When it does, I want
to be able to increment the loop to the next X value. I know I can
Exit the loop with "Exit For". But how do I increment it (i.e. what
Next would do) based on my IF value being true without running the
code under the IF statement?

For X = 1 to 10
If PublicVariableCounter = 30,000 Then [increment X to next value]
Call other modules
Next


Thanks