time to calculate (one cycle)
 

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

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

time to calculate (one cycle)
 

David,

thanks for the reply. I changed it so that the clculation time would be
seen within an excel cell (instead of a message box). Is seems like this is
"forcing" a calculation then timing it.

Is there a way that it will time a calculation as the sheet updates on its
own (I have live data coming in) - the timer would display in a cell (say C3)

"David" wrote:

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