Macro Taking Way to Long

  • Thread starter Thread starter Morgan
  • Start date Start date
M

Morgan

Hey Guys,
I built a macro that seems to slow my computer down a lot.
I just purchased the laptop it has 2.66GHz and 512MB which
should be plenty of space and speed. Right? When I try the
macro on my desktop there are no problems. ANY ideas would
be greatly appreciated.

Thank you in advance. Morgan
..
 
Take a look at
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Since it is faster on desktop, would concentrate more on things like
making sure you don't have journaling turned on in Outlook. Swap
files (paging files) that they are large enough and don't have to
be expanded while you are doing work. Look for other things not
related to specific workbooks If the laptop is not plugged in then
it might run slower.
 
And a couple of easy things to do outside of excel and in your macro:

Close excel, clean up your windows temp folder.

In your code:
set calculation to manual, run your code, reset it to what it was.
Turn screenupdating off when you start and on when you finish.
turn the display of pagebreaks off when you start.


Lots of my macros have this at the top:

Dim CalcMode As Long
CalcMode = Application.Calculation
Application.Calculation = xlCalculationManual
ActiveSheet.DisplayPageBreaks = False

and near the bottom:

Application.Calculation = CalcMode
Application.ScreenUpdating = True
 
Back
Top