breaking out of a loop

  • Thread starter Thread starter ChuckM
  • Start date Start date
C

ChuckM

how do I break out of a loop. As I loop down a column I'd like to
break out of the loop when I find data that meets a particular
condition.
thanks
chuck
 
Chuck:
If using Do...Loop: Exit Do
If using For...Next: Exit For
They will take you to the 1st line of code following Loop or Next.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PasteSpecial method of Range class failed Error 1004 8
how to break out of an if statement and continue to loop 2
End loop 2
Loops stop working and presents "1004': 8
Programmed pause 2
Macro Help 5
Problem with a loop and column references 27
Newb: Asking about a tweak in code 2

Back
Top