Stumped

this will even skip 3, but don't know what you're trying to accomplish

Sub test_loop()
Dim k As Long
For k = 1 To 5

If k = 3 Then
'do nothing
Else
MsgBox k
End If

Next k
End Sub


--


Gary


"Andibevan" <Andibevan@notehere-hotmail.com> wrote in message
news:%23I9sprlBGHA.3064@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> If I try the following I get a Next without For error - Is it possible to
> do
> something like this?
>
>
> Sub test_loop()
>
> For k = 1 To 5
>
> If k = 3 Then
> Next k
> Else
> MsgBox k
> End If
>
> Next k
> End Sub
>
> TIA
>
> Andy
>
>

Sorry - I essentially was wondering whether it was possible to include two
'Next' Statements in one For loop?

"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:uyaAvUqBGHA.684@tk2msftngp13.phx.gbl...
> this will even skip 3, but don't know what you're trying to accomplish
>
> Sub test_loop()
> Dim k As Long
> For k = 1 To 5
>
> If k = 3 Then
> 'do nothing
> Else
> MsgBox k
> End If
>
> Next k
> End Sub
>
>
> --
>
>
> Gary
>
>
> "Andibevan" <Andibevan@notehere-hotmail.com> wrote in message
> news:%23I9sprlBGHA.3064@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > If I try the following I get a Next without For error - Is it possible
to
> > do
> > something like this?
> >
> >
> > Sub test_loop()
> >
> > For k = 1 To 5
> >
> > If k = 3 Then
> > Next k
> > Else
> > MsgBox k
> > End If
> >
> > Next k
> > End Sub
> >
> > TIA
> >
> > Andy
> >
> >
>
>

No, it is not.

It would help to know what you are trying to do, as Kevin O'Neill asked.

If you are trying to increase k by two through using two next statements,
then use step 2 in your for loop.

ex. for k = 1 to 5 step 2




"Andibevan" wrote:

> Sorry - I essentially was wondering whether it was possible to include two
> 'Next' Statements in one For loop?
>
> "Gary Keramidas" <GKeramidasATmsn.com> wrote in message
> news:uyaAvUqBGHA.684@tk2msftngp13.phx.gbl...
> > this will even skip 3, but don't know what you're trying to accomplish
> >
> > Sub test_loop()
> > Dim k As Long
> > For k = 1 To 5
> >
> > If k = 3 Then
> > 'do nothing
> > Else
> > MsgBox k
> > End If
> >
> > Next k
> > End Sub
> >
> >
> > --
> >
> >
> > Gary
> >
> >
> > "Andibevan" <Andibevan@notehere-hotmail.com> wrote in message
> > news:%23I9sprlBGHA.3064@TK2MSFTNGP10.phx.gbl...
> > > Hi,
> > >
> > > If I try the following I get a Next without For error - Is it possible
> to
> > > do
> > > something like this?
> > >
> > >
> > > Sub test_loop()
> > >
> > > For k = 1 To 5
> > >
> > > If k = 3 Then
> > > Next k
> > > Else
> > > MsgBox k
> > > End If
> > >
> > > Next k
> > > End Sub
> > >
> > > TIA
> > >
> > > Andy
> > >
> > >
> >
> >
>
>
>