+ Reply to Thread
Results 1 to 3 of 3

Loop and range problem

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    24

    Loop and range problem

    In the code, each of the ranges is of length 8, filled with double values. For this test they are either 0 a 2 digit decimal. The test hangs executing the 1st line in the loop. I tested Max and it equals 8. The 1st debug.print:
    Debug.Print I, O(I, 1), E(I, 1), L(I, 1)
    seems to print out correctly:
    1 0 0.4 0.2
    although I don't fully understand what's happening in the print out [why does it repeat 3 times?]:
    1 0 0.4 0.2
    1
    1 0 0.4 0.2
    1
    1 0 0.4 0.2
    1
    Please Login or Register  to view this content.
    Last edited by jalea148; 06-29-2012 at 03:22 PM.

  2. #2
    Registered User
    Join Date
    06-19-2012
    Location
    Canada Eh
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    40

    Re: Loop and range problem

    Not sure but your first debug.print call is in a loop so I'm guessing that could be why.
    EF killed Mordred

    46 & 2 is just ahead of me!

  3. #3
    Registered User
    Join Date
    03-20-2012
    Location
    NC
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Loop and range problem

    Quote Originally Posted by FortySixAndTwo View Post
    Not sure but your first debug.print call is in a loop so I'm guessing that could be why.
    It hangs here without the debug.print. thanx.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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