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

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.

--
Regards,
Tom Ogilvy




"Dave Birley" wrote:

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

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!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy




"Dave Birley" wrote:

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