Want to find time taken for the macro

[psk]

Hi
I want to find the time taken for macro..

Can anyone help me in that
How can i staore this value in some text file ..?

Thanks in Advance

[Tornados]

Hi,

Just set a variable at the start of the module

dim starttime as date, endtime as date, duration as date


starttime = now


at the end:

endtime = now

duration = endtime - startime

msgbox duration

Cheers.