View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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