time to calculate (one cycle)
Mike,
to time a full calclation:
sub timeFullCalc()
x = timer
Application.CalculateFull
msgbox timer - x
end sub
--
David
"Mike" wrote:
Hi,
Is there a way to calcualte how long it takes for your spreadsheet to
perform a full calculation?
Or a way to count the number of times your spreadsheet has done a calculation?
through a simple macro or worksheet formula?
thanks
|