+ Reply to Thread
Results 1 to 5 of 5

how to remove the limit from any code in the FOR loop..

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    how to remove the limit from any code in the FOR loop..

    hi,
    i want help in the code below i have been using an alert based programming . in this i have used FOR loop and will check for rows 10000 only i want to make it free from any limit ..it can check endless rows ..please help.. as i have tried putting ten lakh in FOR loop it makes the running very slow or sometimes hangs.
    the startting should be from row 3 but no limit of end row

    i hope that u have understand the problem.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-02-2009
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    77

    Re: how to remove the limit from any code in the FOR loop..

    Use a Do While/Do Until construct

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: how to remove the limit from any code in the FOR loop..

    Um, what are you doing?

  4. #4
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: how to remove the limit from any code in the FOR loop..

    i dont know how to takle this...
    in this i m making the alert functionality that is in this the message box will appear telling u to pay the service tax,vat etc ..regarding my company and if write done in a column it will not give that particular message box..

    in this it will show the message box for only 10000 rows but i want it for all the rows. i cant put all row number in for loop as it hangs. so please help.

  5. #5
    Registered User
    Join Date
    01-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: how to remove the limit from any code in the FOR loop..

    thanks done.. used while loop..... :D

+ 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