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