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
>
>