Excel VBA - exit for loop

Question

I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I think some kind of exit at the end of my if statement, but don't know how that would work.

Dim i As Long
For i = 1 To 50
    Range("B" & i).Select
    If Range("B" & i).Value = "Artikel" Then
        Dim temp As Long
        temp = i
    End If
Next i
Range("A1:Z" & temp - 1).EntireRow.Delete Shift:=xlToLeft

Answer 1

When we need to depart the For Loop based on a set of criteria, we utilise the Exit For statement. The control goes to the next statement immediately after the For Loop when Exit For is invoked.

Syntax
Exit For Statement in VBA syntax is as follows.

Exit For