Hello,

I was wondering how I could set an internal time process
into a macro. Such as how long the macro has been running.

My thought is to display a progress bar that will show the
macros percentage of completion. From a response I
received yesterday (Thank You), I would like to use
something similar to what is on the site http://www.j-
walk.com/ss/excel/tips/tip34.htm.

My only problem is determining how the percentage is
calculated - my thought is to test how long the macro
takes to run - then write that time into my code -
subtracting that time from the amount of time the macro
has been running. But how could I setup this internal
timer?

Any alternative suggestions would also be greatly
appreciated.

Thank You!