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.
could you please post the macro?
Here is the spreadsheet with macro.
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?
maybe something like this
Please Login or Register to view this content.
That works perfectly! Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks