going to next i on certain condition

[Lavina]

Hey guys,

i have a piece of code that is throwing an error: next i without for at the NextIteration part

For i = 2 To lastRow
variableInQuestionReal = Range("L" & i)
variableInQuestionDecimal = GetDecimal(Range("L" & i), False)
If isError(variableInQuestionReal) = true Then GoTo NextIteration
If variableInQuestionDecimal < 0.9 Then variableInQuestionInt = WorksheetFunction.Floor(variableInQuestionReal, 1)
If variableInQuestionDecimal > 0.9 Then variableInQuestionInt = WorksheetFunction.Ceiling(variableInQuestionReal, 1)
Range("O" & i).Value = variableInQuestionInt
Next i
Exit Sub
NextIteration:
Next i

I'm trying to make a manual rounding function and sometimes my data is missing values. I was hoping to just skip over the whole cycle if the value is wrong. Fixing this problem here is easy, but i was wondering how could i stop and skip a part of the cycle if a condition is met?

 

[gallen]

You can't have 2 'Next i's

I don't see why you would because you are close to the solution as you already have 'NextIteration'

If you still struggle, please post the full sub as it's confusing why you have 'Exit Sub'

 

[Stiuart_W]

For i = 2 To lastRow
    variableInQuestionReal = Range("L" & i)
    variableInQuestionDecimal = GetDecimal(Range("L" & i), False)
    If IsError(variableInQuestionReal) = True Then
        If variableInQuestionDecimal < 0.9 Then variableInQuestionInt = WorksheetFunction.Floor(variableInQuestionReal, 1)
        If variableInQuestionDecimal > 0.9 Then variableInQuestionInt = WorksheetFunction.Ceiling(variableInQuestionReal, 1)
    End If
Range("O" & i).Value = variableInQuestionInt
Next i