7 Then Range("D" & row).End(xlToLeft).Select Selection.Interior.ColorIndex = 35 ' exit the loop when we reach row 7 Exit For ' early exit without meeting a condition statement End If ' put any code you want to
it checks for the iterative value, whether it is6or not. If the value is6, then the flag variable is “True“. The loop will skip prematurely and stop the iteration. TheMsgBoxwill show the iterative value where the loop has been executed. Moreover...