"Loop" to exit For loop?

[Guest]

I have a Macro that has a For..Next Loop in it which is (for now) 77 lines
long. Near the top there is a test which requires skipping most of the lines
and looping back to the top. At the moment I am doing this with a label
("NextWS:") parked right above the Next WS command.

In VFP programming there is a simple command ("Loop") which fires me back up
to the top immediately. However, according to the Help File for Excel I don't
see any such option. Is it legal to insert a "Next" command into the
eapression list that results from an If..End If test?

For a = 1 to 10
If a * myVar < 50 Then
Next a
Endif
<lines and lines of code>
Next a

 

[Guest]

No command similar to loop that I am aware of.

for i = 1 to 10
if condition then


end if
Next

is the usual approach.

 

[Guest]

I tried my little sample, and it returned the ol' "Next without For" error.
Just thought that someone would have thought of that approach. I mean, it
would save at least a pico-second in each iteration <g>!

 

[Susan]

would this work?
if it's less than 50, it would do nothing, and skip all the other
coding, going directly to "next a".
? just an idea

For a = 1 to 10
If a * myVar < 50 Then
'do nothing
Else
<lines and lines of code>
End if
Next a

susan

 

[Guest]

In your example, you would switch the sense of your condition:

For a = 1 to 10
If a * myVar >= 50 Then
<lines and lines of code>
end if
Next a