On Apr 19, 7:07 am, "sali" wrote:
consider you are doing nested for/next, it means, n^2 passes.
having 10.000rows, it is 100 milions passes. for 20 minutes, it gives
almost 100.000 pases/second, which realy isn't bad.

nested for/next loop is very unpleasant for processing, is there any chance
to serialize data [instead of n^2 to have a*n processing]?
Serialize the data? Can you explain this a little?

what is your software version, cpu and mem amount?
Excel 2003, Pention D, 3.0Ghz, 3 Gigs RAM

memory augmentation may help dramaticaly

have you monitored task manager and cpu utilization. is it 100%, having
excel taking most of it?
Not yet, will try that back at work since it's a slower machine that I
have here.

. It still takes upwards of 20
minutes for jus a couple thousand records.- Hide quoted text -