try

Sub test()
x = Now()
'
' ur kode
'
MsgBox ("Minute :") & Minute(Now() - x) & " Second :" & Second(Now() - x)
End Sub




"ernestgoh" skrev:


hi, my macro takes a few hours to run. i would like to add a function
inside to measure the time taken. can anyone share how it's done?
thanks.


--
ernestgoh
------------------------------------------------------------------------
ernestgoh's Profile: http://www.excelforum.com/member.php...o&userid=24870
View this thread: http://www.excelforum.com/showthread...hreadid=561815