It sounds like you should be using a database for this, set-processing is
what they are designed for.

MH


"erikhs" wrote in
message ...

Hello everyone,

My problem is this:

I have a large database 10 columns * 40,000 Rows.
One of the titles is a code for identifying the other entry's.
I often have a different spreadsheet, where i draw information out of
the database with the vlookup function. These sheets can consist of up
to 10,000 of the above mentioned codes.
My problem is that when i write this lookup(vlookup) in VBA code for
automation purposes, excel freezes after a minute or so.
I have turned screenupdate and calculation off, although upon exit i
turn the latter on.
Is there anyway around this, like arrays, or is excel simply to slow to
perform these operations?

Thank you in advance


--
erikhs
------------------------------------------------------------------------
erikhs's Profile:
http://www.excelforum.com/member.php...o&userid=32788
View this thread: http://www.excelforum.com/showthread...hreadid=526101