Stop looping through Excel rows (1 Viewer)

TimTDP

Registered User.
Local time
Today, 11:03
Joined
Oct 24, 2008
Messages
210
I use the following to loop though rows in an Excel spreadsheet
Code:
For Row = 1 To CountRow
      code that checks value in cell
Next Row

If the code checking the value in the cell meets certain criteria, I want to stop the loop.
How do I do this?

Thanks
 

JHB

Have been here a while
Local time
Today, 10:03
Joined
Jun 17, 2012
Messages
7,732
The code is:
Code:
Exit For
 

TimTDP

Registered User.
Local time
Today, 11:03
Joined
Oct 24, 2008
Messages
210
Thanks very much
 

Users who are viewing this thread

Top Bottom