How am I able to tell the length of time it takes to run a macro? I have
previously used the =now() function, followed by a paste special
(values) at the start and stop of the macro, but this function only is
as precise as a second. I will need something that can measure to the
millisecond.

Also, is there a way to copy a macro saved in one file, to all of the
files in a folder without using a personal.xls?


--
ducttape
------------------------------------------------------------------------
ducttape's Profile: http://www.excelforum.com/member.php...o&userid=30416
View this thread: http://www.excelforum.com/showthread...hreadid=507441