+ Reply to Thread
Results 1 to 4 of 4

Nested Loop Arrangement

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    36

    Question Nested Loop Arrangement

    Hi guys,

    I seem to have a problem properly arranging my nested loops. In the following code the Do while loop does not seem to perform the For and If loops within it. Any help would be much appreciated.

    Please Login or Register  to view this content.

    Thanks in advance!!.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Nested Loop Arrangement

    I don't really know what your code is meant to do.

    Indenting properly might help to see where the loops, etc., are. And I've asked some questions about values.

    You really need to step through the code and observe the path it takes, depending on the values of the variables.

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    05-08-2012
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Nested Loop Arrangement

    Thanks TMS, your comments made me realise I didnt define my last row.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Nested Loop Arrangement

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find function in nested loop breaking down - not on first time through loop
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 04:59 PM
  2. Nested for-loop
    By Tian1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2014, 07:58 AM
  3. Next without For error in nested loop - Escaping a Nested Loop?
    By BeneRich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2012, 06:38 PM
  4. For each loop nested; getting stuck on one cell in first iteration of nested loop
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2009, 11:54 AM
  5. nested Loop
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2008, 07:26 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1