next iteration in VBA

[kpark91]

Hello,
what is the equivalent of continue of C in VBA?

I currently have a code which checks for prime numbers:

Function checkPrime(a As Double) As Boolean
    For n = 2 To Int(Sqr(a))
        If (n Mod 2 = 0 And n <> 2) Then
            Next n
        ElseIf (a Mod n = 0) Then
            checkPrime = False
            Exit Function
        End If
    Next n
    checkPrime = True
End Function

However, I keep getting an error "Compile Error: Next without for"
The red highlighted line seems to be the trouble.

Thank you in advance,
kpark

 

[GTO]

I am afraid that I do not know C, but it appears you may want:

Function checkPrime(a As Double) As Boolean
    For n = 2 To Int(Sqr(a))
        If (n Mod 2 = 0 And n <> 2) Then
            GoTo NextLoop
        ElseIf (a Mod n = 0) Then
            checkPrime = False
            Exit Function
        End If
NextLoop:
    Next n
    checkPrime = True
End Function

 

[kpark91]

Perfect! Thank you very much

 

[GTO]

You are most welcome; its always nice when its an easy fix