Prev: Refresh of Data
Next: Excel creates temporary files
From: CousinExcel on 13 May 2010 06:50
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


From: Mike H on 13 May 2010 07:10
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
>
>
From: Gary''s Student on 13 May 2010 07:17
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
>
>
From: CousinExcel on 13 May 2010 08:03
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
> >
> >
 | 
Pages: 1
Prev: Refresh of Data
Next: Excel creates temporary files