Hello,

I am loading a 14,000 line range into an array.

I am then looping through each element of that array, and using the find
method, am checking to see if that value is in a 40,000 line range in
another workbook.

This is running hopelessly slow, taking 30 minutes to execute.

Screenupdating and Calcuation are both off.

Any ideas would be greatly appreciated.

Thanks
Ariel

Post a stripped down version of your code, enough to show the each part of
your methods.

Regards,
Peter T

"AD" wrote in message
...
Hello,

I am loading a 14,000 line range into an array.

I am then looping through each element of that array, and using the find
method, am checking to see if that value is in a 40,000 line range in
another workbook.

This is running hopelessly slow, taking 30 minutes to execute.

Screenupdating and Calcuation are both off.

Any ideas would be greatly appreciated.

Thanks
Ariel

Try loading the 40000 line range into a second array. Depending on how you
access the cells in the range, you can greatly change the speed of the
routine. Also, you might try a binary lookup on a sorted array.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AD" wrote in message
...
Hello,

I am loading a 14,000 line range into an array.

I am then looping through each element of that array, and using the find
method, am checking to see if that value is in a 40,000 line range in
another workbook.

This is running hopelessly slow, taking 30 minutes to execute.

Screenupdating and Calcuation are both off.

Any ideas would be greatly appreciated.

Thanks
Ariel

Thanks,

I'll try your suggestions

Ariel


"Jon Peltier" wrote in message
...
Try loading the 40000 line range into a second array. Depending on how you
access the cells in the range, you can greatly change the speed of the
routine. Also, you might try a binary lookup on a sorted array.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AD" wrote in message
...
Hello,

I am loading a 14,000 line range into an array.

I am then looping through each element of that array, and using the find
method, am checking to see if that value is in a 40,000 line range in
another workbook.

This is running hopelessly slow, taking 30 minutes to execute.

Screenupdating and Calcuation are both off.

Any ideas would be greatly appreciated.

Thanks
Ariel