AT the start

nTimer = Timer
... your code
Debug.Print Timer - nTimer

will give you an indicative answer, it is not absolute because there is so
much else going on.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pradip Jain" wrote in message
...
I want to check the time (in seconds) which my macro takes to run.
what code can be used.

thanks
pradip