Thread
:
Macros go slower than a turtle in mud
View Single Post
#
2
Posted to microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
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
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey