Timing Excel computations
Hi,
You can use:
Sub GetTime()
T1 = Timer
'You code here
T2 = Timer
TEnd = T2 - T1
MsgBox TEnd
End Sub
Rgds,
Halim
Schizoid Man menuliskan:
Hi,
I'm trying to crunch a pretty large set of numbers and once I fire up
the function the spreadsheet takes up to 3-4 minutes to finish running.
I want to write the time taken from start to finish to a cell.
Can someone please help?
Thanks,
Schiz
|