Else statement in loop

[Bob Phillips]

I didn't know that I must use a Exit Sub. So I'll remember that!

You wouldn't normally, in your case you want to stop that procedure early, so exiting is one way.

IMO, you should be moving the code after the Else … End If into the IF part of the code if that is the only time that you want it executed. Then you would not need to add the Exit Sub.