CODEWITHSUNDEEP
vbaexcel
abin kurian
abin kurian

Reputation: 41

Skipping an iteration in for loop (VBA excel)

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.

Upvotes: 1

Views: 125

Answers (1)

ashleedawg
ashleedawg

Reputation: 21619

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

Upvotes: 4

Related Questions