On Dec 13, 10:36 am, ilia wrote:
I'm trying to replicate your results. Here is what I'm getting.
Results 45 through 49 were when I switched to the browser window =]
1: n=1000 1016 msec
2: n=1000 688 msec
[....]
63: n=1000 672 msec
This appears to be the result of a single run with maxCnt=63 and
maxN=1000. If so, you are missing the point. Run it one time after
modifying the macro, then run it a second time (or more) without
changing the macro. If you are duplicating my observation, you will
see a significantly higher average. FYI, it should not be necessary
to have such a large maxCnt. Typically, my maxCnt is 10 or 20.
PS: I should have mentioned that I am using Office Excel 2003 with
VB
6.3, although the About box also says VBA 6.4.8869.