+ Reply to Thread
Results 1 to 3 of 3

Conditionally change nested loops

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Wellington NZ
    MS-Off Ver
    Excel 2003
    Posts
    7

    Conditionally change nested loops

    Hi all. I'd like to be able to conditionally change the number of nested loops.

    Please Login or Register  to view this content.
    That's fine. But I'd like to be able to have, say 3 or more nested loops depending on variables supplied.

    Kind regards

    Andy G

  2. #2
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Karlstad, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    232

    Re: Conditionally change nested loops

    Maybe you can use Select Case

    Please Login or Register  to view this content.
    1. Reply to thread and inform if suggestion was helpful or not
    2. Click on the star (=Add Reputation) if you think someone helped you
    3. Mark [SOLVED] to this thread if solution was found. (On Menu "Thread Tools" > "Mark this thread as solved")

  3. #3
    Registered User
    Join Date
    10-08-2012
    Location
    Wellington NZ
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Conditionally change nested loops

    Thanks so much Joakim!

    That should work ok, I guess I could branch to separate functions for added eloquence. I'll keep the thread open a little while in case of other replies. I was considering recursion but couldnt get my head around it.

    Andrew

+ 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. [SOLVED] Nested IF loops More than 7 Need Help
    By EricSomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 02:25 PM
  2. [SOLVED] Help with nested loops
    By wishmaker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2013, 11:03 AM
  3. [SOLVED] Nested Loops
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2012, 07:29 AM
  4. Nested loops VBA
    By zurich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2012, 03:21 PM
  5. Nested Loops
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2009, 04:14 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