+ Reply to Thread
Results 1 to 4 of 4

speed up vba code within excel macro

  1. #1
    Registered User
    Join Date
    12-02-2009
    Location
    K.MATZKIN
    MS-Off Ver
    Excel 2010
    Posts
    5

    speed up vba code within excel macro

    good day

    please how i speed up vba code within excel macro

    thanks moshe

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: speed up vba code within excel macro

    Two standard ways of doing this are to avoid using SELECT which appears frequently when a macro is recorded and Application.Screenupdating = False to remove the need for the application to spend time updating the screen.
    Martin

  3. #3
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: speed up vba code within excel macro

    We see a lot of code posted here, which in addition to the issues above, is looping through a large number of cells trying to match a value. That can take a very long time - learn to use the .Find method.

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,417

    Re: speed up vba code within excel macro

    I asked a similar question a while back. Have a look at the responses to my thread on code efficiency. It may provide you with some ideas.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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