Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a procedure that loops through 14 data sets, evaluating the
variables for inclusion in a model. I find that when I LOOP through the 14 iterations, the performance seems "bogged-down", and often results in 'not enough memory' errors and the like. Code sample: i = 1 Do while i <= 14 ...CODE.... ...CODE.... ...CODE.... i = i +1 Loop Executing each iteration manually, however, results in more efficient processing, no errors, and accurate results. The problem, of course, is that I'd like to LOOP so I can start the procedure, go to sleep, and awake with accurate results. Instead I am a slave to the computer to affect one key-stroke every 30 mins. This evidence begs the question: How does the computer differentiate the two approaches? How can I programmatically replicate the difference? Any thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
for loop with if statement | Excel Worksheet Functions | |||
Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
If statement - Loop? | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
Faster For-Next Loop? | Excel Programming |