Question, I have a macro that runs fast, about 7 seconds the first time I run it after I open the file. The macro runs from a button I push and runs fast and fresh the first time. The second time I run it, it takes about a minute. Just wondering what things usually cause that, is something being held in memory? I know that is not a lot of info, but just wondering if there is some code that fixes this, or is there a common reason for it that one of you might be able to suggest.
Last edited by caliskier; 02-06-2014 at 02:10 PM.
Update... I noticed I can run it several times no problem, but when I go in and check printpreview, and then later run the macro after comming back out of print preview it slows down. So it is the act of going into print preview that is causing this problem. The only way to speed it back up after that is to close it out and reopen. Any ideas there?
Solved... This might help someone.... Found this on another site..
Page breaks can certainly slow down macros, because each time
you insert/delete/hide/unhide a row you will force Excel to recalculate those
breaks.
To eliminate these calculated page breaks
Tools, Options, View, uncheck "Page Breaks" or in a macro
ActiveSheet.DisplayPageBreaks = False
I would like to add one more point for anyone this might help, the thing that is really fixing this for me is to go into File>options>advanced> Display Options for this Worksheet. Now uncheck "Show Page Breaks". Doing this is the only thing that worked for me. The instructions above are for excel 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks