breaking out of a loop
 

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

breaking out of a loop
 

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.
--
George Nicholson

Remove 'Junk' from return address.


"ChuckM" wrote in message
m...
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