View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Macros go slower than a turtle in mud

Hard to tell if you don't give us the code.

One thought: Are your machines that race like the wind set for Manual
Calculation?
(You can set that in your macro, then set it back when it exits:

Dim oldCalcMode As Long
With Application
oldCalcMode = .Calculation
.Calculation = xlCalculationManual
End With

'your code

Application.Calculation = oldCalcMode

You might take a look at Charles Williams' site, both for speed tips and
for his FastExcel application:

http://www.decisionmodels.com/optspeed.htm

In article ,
(BOHICA) wrote:

I do not know what the exact problem is, but on some machines, my
macros I have created (like my machine) run like the wind just as I
intend them to...but on other machines, they run like a one legged man
with a bad knee. WHY?!?!

The machines might be the exact same running the same service packs
and patches. Some days, the macros run fast too. What the hell is
happening to my macros? Do they take union breaks or something?

Thanks in advance