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