display how long it takes to calc or timing certain events

  • Thread starter Thread starter GH
  • Start date Start date
G

GH

The glorious excel application that I have been constructing over the
past month is getting very sloooooowwwwww. I have done the obvious
like turning off screen updating and turning off automatic calculation
while the code is running and pasting stuff in cells.

Even the automatic calculation that executes when the user updates a
single cell is slow.

I would like to time how slow. Can you somehow display a clock or
timer to measure whether certain modification to the code improve the
speed? I would like to be able to quantify questions like: "How much
faster is the calculation if all UDF functions are made non-volatile?"
 
Hi Gh,
I would like to time how slow. Can you somehow display a clock or
timer to measure whether certain modification to the code improve the
speed? I would like to be able to quantify questions like: "How much
faster is the calculation if all UDF functions are made non-volatile?"
Click to expand...

If you can wait a few weeks, our book "Professional Excel Development"
includes a chapter about optimizing VBA performance and provides a
performance monitoring addin that does exactly what you require.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 
Back
Top