Consulting

Results 1 to 3 of 3

Thread: Macro speed

  1. #1
    VBAX Newbie
    Joined
    Aug 2010
    Posts
    3
    Location

    Question Macro speed

    I have a macro that works properly. In certain cases, this macro has to work through twelve nested for loops a total of tens of millions of times and when this happens, the macro takes many minutes to complete. Question: Is there some way to make the code execute faster? Note that I have been through the code and I believe that it is properly and efficiently written.

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,805
    Location
    Quote Originally Posted by groston View Post
    it is properly and efficiently written.
    If that is true, then no.
    Be as you wish to seem

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,895
    Location
    1. Faster computer

    2. Post the macro so we can least look at the properly and efficiently written macro
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •