Can't you just copy part of it to a reply? Or, more fully describe the
situation.
If not, and the file is SMALL (on 56k modem), send to

wrote in message
...
It's a lot of code in different modules and I think it
would be very difficult to get an overview here. Is it
possible for me to send you my excelfile with the original
code?

Or perhaps copy the code into NotePad, MS Word...?

Please respond to this!

/jonas

-----Original Message-----
Post your code. Do NOT attach file

"Haettner" wrote in
message
...
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


.