Using VBA 6.5

First run, maxCnt = 10
1: n=1000 828 msec
2: n=1000 719 msec
3: n=1000 734 msec
4: n=1000 703 msec
5: n=1000 719 msec
6: n=1000 703 msec
7: n=1000 719 msec
8: n=1000 719 msec
9: n=1000 703 msec
10: n=1000 719 msec

Modified:
1: n=1000 703 msec
2: n=1000 719 msec
3: n=1000 719 msec
4: n=1000 703 msec
5: n=1000 719 msec
6: n=1000 719 msec
7: n=1000 718 msec
8: n=1000 703 msec
9: n=1000 719 msec
10: n=1000 766 msec

Run again, without modifying:
1: n=1000 766 msec
2: n=1000 719 msec
3: n=1000 718 msec
4: n=1000 719 msec
5: n=1000 719 msec
6: n=1000 703 msec
7: n=1000 719 msec
8: n=1000 718 msec
9: n=1000 704 msec
10: n=1000 718 msec

Again, cannot replicate your results. I could run it all day and
average 719 ms, with the programs I currently have running.


On Dec 13, 7:35 pm, joeu2004 wrote:
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.