"Loop" to exit For loop?
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
--
Dave
Temping with Staffmark
in Rock Hill, SC
|