I have a Do While...Loop processing an array of 8500
records. Each record is transferred to a single row in
another workbook. A number of procedures is processed on
each row and then next record is transferred. Look at the
data below!

Why is this happening??? The speed is excellent the first
5 minutes but then its a disaster! Is Excel "eating"
memory? Is it possible to allocate memory, if that is the
problem, by some method in VBA? Or.....?

I would be VERY happy to a solution!

/jonas haettner

Time No of processed records Records/min
0 - 5 min 3700 750
5 - 10 min 4575 163
10 - 16 min 5392 136
16 - 21 min 5970 116
21 - 26 min 6486 103
26 - 31 min 6957 94
31 - 36 min 7377 84
36 - 41 min 7800 85
41 - 46 min 8190 77
46 - klart 8420