+ Reply to Thread
Results 1 to 3 of 3

Macro running slower and slower

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Slovakia
    MS-Off Ver
    2007, 2010, 2013
    Posts
    76

    Angry Macro running slower and slower

    Could you good fellows help me to analyse, why my piece of code is runnig slower and slover each time the button-trigger is pressed (more checkboxes and rows added)? I am strugling with it for a months now... :( Many thanks in advance for any ideas...

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Re: Macro running slower and slower

    I notice you don't turn off Screen Updating. Putting this line at the beginning of your macro (and turning it off at the end) will help a lot:
    Please Login or Register  to view this content.
    I'd also try stop all the selecting. Untested, but maybe as shown below:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-13-2015
    Location
    Slovakia
    MS-Off Ver
    2007, 2010, 2013
    Posts
    76

    Re: Macro running slower and slower

    Turning off the screenupdating helped a lot . Thanks.

+ 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. [SOLVED] Macros running much slower than they had been
    By nebb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2014, 06:56 PM
  2. Slower cpu's affecting macro
    By welshman010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2014, 09:42 PM
  3. [SOLVED] Suddenly slower running code...
    By fgruhlke in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2014, 11:20 PM
  4. Excel macro getting slower and slower.
    By swoop99 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-24-2011, 06:41 AM
  5. Macros running much slower in 2007/Win7
    By surfengine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2010, 05:51 PM
  6. VBA routine gets slower and slower on each iteration of the main loop
    By whitespaces in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-15-2009, 03:29 AM
  7. [SOLVED] Excel gets slower and slower....
    By Romuald in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2005, 10:05 AM

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