time how long a macro takes

[shadow12345]

I would like to time how long a macro takes to complete and use debug print at certain points in the code so i can have a note of how long each section is taking.

any ideas?

 

[HalfAce]

Sure.
Try putting this line where you want to start timing:
A = Time
then your code and this where you want to stop
B = Time.

And show it however you like. (ie.) MsgBox ("Run time = " & A - B)

Hope it helps.

 

[Blade Hunter]

Sure.
Try putting this line where you want to start timing:
A = Time
then your code and this where you want to stop
B = Time.

And show it however you like. (ie.) MsgBox ("Run time = " & A - B)

Hope it helps.

B - A not A - B

 

[shadow12345]

indeed.... see its not as hard as i thought then.

That should be enough

cheers.

 

[HalfAce]

YES! YES!... Blade Hunter's right!
B - A not A - B

Good eye man.
Thanks for keeping me honest!