View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] halimnurikhwan@yahoo.com is offline
external usenet poster
 
Posts: 113
Default 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