update of worksheet cell extremely slow
Have you done the following before execution
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
And at the end
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
HTH,
Barb Reinhardt
"Måns Tånneryd" wrote:
Hi!
We have a very simple VBA procedure that generates and writes random numbers
into a worksheet cell. On most of our client computers this runs as fast as
you would expect but on a few of them it takes forever. We have not been able
to figure out why. Anyone out there who knows what could make excel consume
huge amounts of cpu cycles when writing to a worksheet cell?
/Måns
|