Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question on determining "ROW" inside of a "For .. RANGE " loop | Excel Programming | |||
Find all cells NOT containing "100%" -no loop solution needed | Excel Programming | |||
Loop through ".DAT" files, open run code, close next | Excel Programming | |||
LOOP BETWEEN "FRONT" AND "END" SHEETS? | Excel Programming | |||
how to stop program with loop by click "Cancel" button | Excel Programming |