For Next Loop Question

Learned by accident or from a post or somewhere else????

Curious minds want to know <g>.



Tom Ogilvy wrote:
>
> An interesting fact I learned not too long ago:
>
> Sub ABC()
> For n = 1 To 10
> For m = 1 To 10
> For o = 1 To 10
> For p = 1 To 10
> Debug.Print n, m, o, p
> Next p, o, m, n
>
> End Sub
>
> --
> Regards,
> Tom Ogilvy
>
> "aidan.heritage@virgin.net" wrote:
>
> > It's probably good practice to write
> >
> > for n=1 to 10
> > do something
> > next n
> >
> > but it's exactly the same as
> >
> > for n=10 to 10:do something:next
> >
> > Reason for being good practice is
> >
> > for n=1 to 10
> > for m = 1 to 10
> > for o=1 to 10
> > for p = 1 to 10
> > next
> > next
> > next
> > next
> >
> > is harder to read!!! (and to debug - ESPECIALLY if the for next loops
> > are nested further apart than my example!
> >
> >

--

Dave Peterson

From someone else's post. That's why were all really here <g>

--
Regards,
Tom Ogilvy



"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44776ECE.A9268912@verizonXSPAM.net...
> Learned by accident or from a post or somewhere else????
>
> Curious minds want to know <g>.
>
>
>
> Tom Ogilvy wrote:
> >
> > An interesting fact I learned not too long ago:
> >
> > Sub ABC()
> > For n = 1 To 10
> > For m = 1 To 10
> > For o = 1 To 10
> > For p = 1 To 10
> > Debug.Print n, m, o, p
> > Next p, o, m, n
> >
> > End Sub
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "aidan.heritage@virgin.net" wrote:
> >
> > > It's probably good practice to write
> > >
> > > for n=1 to 10
> > > do something
> > > next n
> > >
> > > but it's exactly the same as
> > >
> > > for n=10 to 10:do something:next
> > >
> > > Reason for being good practice is
> > >
> > > for n=1 to 10
> > > for m = 1 to 10
> > > for o=1 to 10
> > > for p = 1 to 10
> > > next
> > > next
> > > next
> > > next
> > >
> > > is harder to read!!! (and to debug - ESPECIALLY if the for next loops
> > > are nested further apart than my example!
> > >
> > >
>
> --
>
> Dave Peterson

I missed that one. Thanks for sharing.

It kind of looks like something that Tushar would like/do <vbg>.

Tom Ogilvy wrote:
>
> From someone else's post. That's why were all really here <g>
>
> --
> Regards,
> Tom Ogilvy
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:44776ECE.A9268912@verizonXSPAM.net...
> > Learned by accident or from a post or somewhere else????
> >
> > Curious minds want to know <g>.
> >
> >
> >
> > Tom Ogilvy wrote:
> > >
> > > An interesting fact I learned not too long ago:
> > >
> > > Sub ABC()
> > > For n = 1 To 10
> > > For m = 1 To 10
> > > For o = 1 To 10
> > > For p = 1 To 10
> > > Debug.Print n, m, o, p
> > > Next p, o, m, n
> > >
> > > End Sub
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "aidan.heritage@virgin.net" wrote:
> > >
> > > > It's probably good practice to write
> > > >
> > > > for n=1 to 10
> > > > do something
> > > > next n
> > > >
> > > > but it's exactly the same as
> > > >
> > > > for n=10 to 10:do something:next
> > > >
> > > > Reason for being good practice is
> > > >
> > > > for n=1 to 10
> > > > for m = 1 to 10
> > > > for o=1 to 10
> > > > for p = 1 to 10
> > > > next
> > > > next
> > > > next
> > > > next
> > > >
> > > > is harder to read!!! (and to debug - ESPECIALLY if the for next loops
> > > > are nested further apart than my example!
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson