+ Reply to Thread
Results 1 to 6 of 6

Macro slows down with each successive run

  1. #1
    Registered User
    Join Date
    05-07-2009
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    17

    Macro slows down with each successive run

    I have a macro created with the Record Macro function and linked to a button in an Excel 2007 worksheet. The first time the macro blazes through but with each additional run it slows down until after 5 or 6 times it barely functions. I tried clearing the clipboard between runs but it did not help. Is this a VBA issue? I have no VBA skills. I can post the worksheet if needed but was hoping it might be a simpler fix.
    Last edited by hillbk; 03-07-2013 at 11:52 PM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Macro slows down with each successive run

    could you please post the macro?

  3. #3
    Registered User
    Join Date
    05-07-2009
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Macro slows down with each successive run

    Here is the spreadsheet with macro.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-07-2009
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Macro slows down with each successive run

    After doing some addition sleuthing I was able to isolate the problem to the conditional formatting in the table. When the table gets copied, revised, and then pasted back into its original location the conditional formatting gets added to the previous formatting so that every time the macro is ran the conditional formatting list for each cell gets progressively longer. When I deleted the formatting the macro blazed through every time. Is there a way to keep the formatting from duplicating?

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: Macro slows down with each successive run

    maybe something like this
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-07-2009
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Macro slows down with each successive run

    That works perfectly! Thanks.

+ 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