exit for next loop
 

Is there a command to "Exit" a for next loop ?
Thanks in advance
David

Values = False
Dim ofcells As Range
For Each ofcells In Range("myrange")
If ofcells.Value < 0 Then
Values = True
Can I exit loop from here
End If
Next
to carry on from here

exit for next loop
 

I think it is "exit for"

"David Henderson" wrote:

Is there a command to "Exit" a for next loop ?
Thanks in advance
David

Values = False
Dim ofcells As Range
For Each ofcells In Range("myrange")
If ofcells.Value < 0 Then
Values = True
Can I exit loop from here
End If
Next
to carry on from here

exit for next loop
 

Surprise! "Exit For" is the way to exit a FOR... statement group.