Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro, slow performance on terminal server... | Excel Programming | |||
Macro performance | Excel Discussion (Misc queries) | |||
poor macro performance | Excel Programming | |||
Performance problem with VB Macro in Excell XP | Excel Programming | |||
problem with performance of excel macro, pls help | Excel Programming |