Do While works with Exit Do as you discovered.
Microsoft recommends using Do...Loop instead of While...Wend as "The Do...Loop statement provides a more structured and flexible way to perform looping."
The documentation for While...Wend does not offer the Exit structure at While...Wend statement (VBA) | Microsoft Docs
Last edited by davegri; 03-15-2022 at 10:51 PM. Reason: more detail
Yes, the $MS description doesn't offer an example. I often code loops through recordsets using "While..........Wend", but this is the first time in recent memory that I had an occasion to exit the loop. With this caper, I'll start using "Do While............ Loop" structure so I don't bump my head again. Even old geezers can change their ways
Thanks,
Bill