If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exit to the beginning of For Next loop
Hi,
For i=1 to 5 if .... then .... .... GO TO THE BEGINNING OF FOR NEXT LOOP end if .... .... next i What should I say to mean "GO TO THE BEGINNING OF FOR NEXT LOOP" above (if I can). Thanks and regards, Cousin Excel |
#2
|
|||
|
|||
Exit to the beginning of For Next loop
Hi,
In the If statement you can test for a condition then if satisfied exit the for next loop For i = 1 To 5 if my condition is met then Exit For End If Next i -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "CousinExcel" wrote: Hi, For i=1 to 5 if .... then .... .... GO TO THE BEGINNING OF FOR NEXT LOOP end if .... .... next i What should I say to mean "GO TO THE BEGINNING OF FOR NEXT LOOP" above (if I can). Thanks and regards, Cousin Excel |
#3
|
|||
|
|||
Exit to the beginning of For Next loop
Sub demo()
For i = 1 To 5 v = Cells(i, 1).Value If v 10 Then Cells(i, 2).Value = "Big" GoTo skiput End If Cells(i, 2).Value = "Little" skiput: Next i End Sub -- Gary''s Student - gsnu201003 "CousinExcel" wrote: Hi, For i=1 to 5 if .... then .... .... GO TO THE BEGINNING OF FOR NEXT LOOP end if .... .... next i What should I say to mean "GO TO THE BEGINNING OF FOR NEXT LOOP" above (if I can). Thanks and regards, Cousin Excel |
#4
|
|||
|
|||
Exit to the beginning of For Next loop
Many thanks.
CousinExcel "Gary''s Student" wrote: Sub demo() For i = 1 To 5 v = Cells(i, 1).Value If v 10 Then Cells(i, 2).Value = "Big" GoTo skiput End If Cells(i, 2).Value = "Little" skiput: Next i End Sub -- Gary''s Student - gsnu201003 "CousinExcel" wrote: Hi, For i=1 to 5 if .... then .... .... GO TO THE BEGINNING OF FOR NEXT LOOP end if .... .... next i What should I say to mean "GO TO THE BEGINNING OF FOR NEXT LOOP" above (if I can). Thanks and regards, Cousin Excel |
Thread Tools | |
Display Modes | |
|
|