+ Reply to Thread
Results 1 to 2 of 2

Looping Problem

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Singapore
    Posts
    79

    Looping Problem

    Hey all,

    I desperately need some help.

    I've created a loop with certain conditions in it. Here's my situation - When I loop it using a fixed number of rows, everything works fine. But when I use a dynamic number of rows, it does not work properly. I cannot figure out why.

    Please refer to the attachment and you will understand my problem immediately.

    This post was cross-posted in http://www.mrexcel.com/forum/showthr...32#post1667132

    Please help, anyone!
    Attached Files Attached Files

  2. #2
    Forum Contributor SOS's Avatar
    Join Date
    01-26-2004
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    327
    Hi carddards,

    Your lastrow variable in the fixed routine loops 10 times but in your dynamic routine only as many times as there are cells in Column A (ie 6 times)

    If you changed the dynamic routine to count the cells in column F it works ie

    Please Login or Register  to view this content.
    Hope this helps

    Seamus

+ 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. Excel 2007/ Outlook 2007 mail Problem
    By Bostock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2007, 04:26 PM
  2. Countif funtions problem
    By mike4545 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2007, 02:37 PM
  3. Cell function problem
    By itty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2007, 08:27 AM
  4. Complex nested array formula problem and challenge
    By PeterWilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2007, 10:34 PM
  5. Looping Problem
    By Stuie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2006, 12:15 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