For Next - Resolved I reckon

[Spajeoly]

Isn't there a way to set 2 ranges in a For Next loop?

Say

For i = 0 To 10 AND 30 to 45

I thought it was possible, but I am likely wrong...

[isnoend07]

Isn't there a way to set 2 ranges in a For Next loop?

Say

For i = 0 To 10 AND 30 to 45

I thought it was possible, but I am likely wrong...

you can do
For i = 0 To 10
for x = 30 to 45

[Spajeoly]

One loop, not 2. I think I am just high or something

So basically have I go from 0 To 10 then 30 to 45

[Siddharth Rout]

If it just that example then you can do something like this.... just a workaround...

Private Sub Sample()
    Dim i As Long
    '~~> For i = 0 To 10 AND 30 to 45
    For i = 0 To 45
        If i < 11 Or i > 29 Then
           '~~> Your code
        End If
    Next i
End Sub

[Logophobic]

Another workable solution:

For i = 0 to 45
   If i = 11 Then i = 30
   ' ...
Next i

[Spajeoly]

Yeah, I reckon I can settle for that.

I don't know where I thought I had seen this but I was obviously just being retroactively mistaken.

[Siddharth Rout]

AFAIK there is no way to keep them in the same line as you want it....

So Is your query resolved?

[Spajeoly]

Fine

[Siddharth Rout]

Then do remember to mark this thread resolved Check the link in my signature on how to mark the thread resolved

[Logophobic]

I don't know where I thought I had seen this...

Perhaps in Select Case syntax:

Select Case X
Case 0 To 11, 30 To 45
...
End Select

[Code Doc]

Correct, LogoPhobic. The For ... Next coupled with the Select Case ... End Select will work.

[Spajeoly]

Then do remember to mark this thread resolved Check the link in my signature on how to mark the thread resolved

I am well aware of the process of editing a thread, I have 2 years on you here after all.

I had marked it resolved before your reply as well, so please do remember to check before commanding.

[si_the_geek]

Marking a thread as resolved does not need to involve the effort of editing - and while you have added the word Resolved to the title, it is far from the manner we all expect it, so it is easy to miss (I had to check twice if it was there for koolsid's reply!).

[Siddharth Rout]

I am well aware of the process of editing a thread, I have 2 years on you here after all.

I had marked it resolved before your reply as well, so please do remember to check before commanding.

@Spajeoly: I know you have been in the forum much before me but what made you think that I was commanding ? It was just a simple polite request

The idea behind marking a thread is to let other members know that your problem is sorted so that they don't waste their time