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