Skipping an iteration in for loop (VBA excel)

Question

I have a piece of code in which i would like the for loop to continue to the next value of i if the value in a cell is "nil" and not execute the commands in the loop. I am unable to figure it out.

For i = 2 To n
    If .Cells(i, "G").Value = "nil" Then
        next i
    Else
        mon = month(.Cells(i, "G").Value)
        acctyp = .Cells(i, "P").Value
    end if
next i

Thanks in advance.

since the variable mon is an integer i would not take in the month(nil) argument . — abin kurian
– abin kurian, Commented Sep 24, 2018 at 7:51
You really shouldn't need a GoTo statement in this though. The If should handle it — Tom
– Tom, Commented Sep 24, 2018 at 9:07
Your loop will work fine if you just remove the first Next i - replace it with a comment if that helps 'Do Nothing. — Darren Bartrup-Cook
– Darren Bartrup-Cook, Commented Sep 24, 2018 at 9:09

Geert Bellekens · Accepted Answer · 2018-09-24 13:14:25Z

4

The comparison operator <> means "not equal to":

For i = 2 To n
    If .Cells(i, "G") <> "nil" Then
        mon = Month(.Cells(i, "G"))
        acctyp = .Cells(i, "P")
    End If
Next i

edited Sep 24, 2018 at 13:14

Geert Bellekens

13.9k3 gold badges31 silver badges57 bronze badges

answered Sep 24, 2018 at 13:08

ashleedawg

21.9k9 gold badges82 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ashleedawg Over a year ago

@abinkurian - you're welcome . . . just to clarify, there are several comparison operators. Here is a list.

Collectives™ on Stack Overflow

Skipping an iteration in for loop (VBA excel)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related