Hi all

I am trying to figure out what section of my code is running the longest.

how do i compare two times (ie subtract the two so that i can get a total
time run)

sub MyCode()
dim t1, t2, total
t1=time
<my code>
t2=time

total=<how do i work with the time here>
msgbox total
end sub

is this the correct way to do this or is there a better way?

and secondly is there a way to write one sub and have it triggered any time
that code is run, without putting a call to it in each of my functions?

basically i want to see how long each section of my code takes to run, so i
can see where the slowdowns are and possibly re-write, etc


tia!

J