Now()

[viper]

I'm wanting to time my macro. I've tried several things. Can Now() be saved in a variable? I mean, if I put start = Now() at the beginnig of my macro will the time stay in start? Because I also want to put finish = Now() at the end of my macro. If doing so will start and finish end up with the same time? I then want a msgbox to tell me how long the macro took to complete. I've tried a progress bar but that didn't work. So I'm thinking maybe this way.

thanks,

 

[PaddyD]

one way:

<pre>

Sub timeit()

Range("b1").Value = Now

yourmacro

Range("b2").Value = Now

End Sub


</pre>

Paddy

 

[PaddyD]

If you want a message box:


<pre>

Sub timeit()

Dim a As Date
Dim b As Date

a = Now

yourmarco

b = Now

MsgBox Format(b - a, "hh:mm:ss")


End Sub


</pre>


Paddy