For loop to only work once then exit

**JDodger** · 03-02-2014, 03:14 PM

I'm trying to make a For.. Next. that will find the relevant cell in a row starting at the bottom, and then once it has found it, grab the row number and then exit the for.

Would I do it like:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Also instead of matchingRow = x, how do I grab the row number?

Thanks a lot in advance

**Norie** · 03-02-2014, 03:22 PM

i will give you the matching row.

**JDodger** · 03-02-2014, 03:25 PM

Oh yeah of course... woops :') But which code do I use for the first question?

**Norie** · 03-02-2014, 03:29 PM

The second code you posted should do the job.

The first won't actually compile as Next i/End If is the wrong way round.

For loop to only work once then exit

LinkBack

Thread Tools

Rate This Thread

Display

For loop to only work once then exit

Re: For loop to only work once then exit

Re: For loop to only work once then exit

Re: For loop to only work once then exit

Thread Information

Users Browsing this Thread

Similar Threads

Exit Loop If Value Not Matched

[SOLVED] Exit for each loop condition[s]

Exit loop

exit loop when find value?

[SOLVED] exit for next loop

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions