Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: To Break For Each Loop.

  1. #1
    Join Date
    20th July 2006
    Posts
    50

    To Break For Each Loop.

    Its really basic but i cant find answer to this question.

    How to break For Each Loop?

    I am looking for something simmilar to C++ break; command.

    Thanks.

  2. #2
    Join Date
    8th September 2004
    Location
    Northampton, England
    Posts
    2,606

    Re: To Break For Each Loop.

    If you put an If test statement within your loop, when the condition occurs that requires you to jump out of the loop, use
    VB:
    Exit For 
    
    
    Hope this helps.
    Regards,
    Batman.

  3. #3
    Join Date
    20th July 2006
    Posts
    50

    Re: To Break For Each Loop.

    Thankyou.

  4. #4
    Join Date
    8th September 2004
    Location
    Northampton, England
    Posts
    2,606

    Re: To Break For Each Loop.

    You're very welcome!
    Regards,
    Batman.

Thread Information

Users Browsing this Thread

There are currently 3 users browsing this thread. (0 members and 3 guests)

Possible Answers

  1. Replies: 0
    Last Post: December 14th, 2007, 13:22
  2. Code errors without break, none with break
    By jmhans in forum EXCEL HELP
    Replies: 1
    Last Post: January 26th, 2005, 03:31
  3. Break out of a loop
    By Bon in forum EXCEL HELP
    Replies: 4
    Last Post: October 17th, 2004, 17:09

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno