I need a VBA If Else statement within a For Next loop
I have tried various arrangements of the statements, but they all error out.
Sub TestForIfElse()
Dim Counter As Integer
Dim i As Integer
For i = 1 To 5
Counter = i
If Counter > 3 Then
Exit For
Else
Next i 'ERROR NEXT WITHOUT FOR
End Sub
Run loop until test is met.
If Test not met, keep going
If test met, exit loop. Thanks for your help.
Aucun commentaire:
Enregistrer un commentaire