Out of memory error

Hi, I got help with this code a while ago – And it works great!
However, now my data set is bigger and I’m getting an “out of memory” error.

This is what I’m doing:

- Sheet 1 and 2 have data in 20-80 columns with 100k-600k rows.
- Both sheets have an “Unique-ID” in column A – of which about 80% match.
- Purpose: New sheet 3 with the matches from sheet 1 and 2 in the same row.

Is there a way to make the code more efficient?

I'm having trouble with attaching files, does linking work?
http://www.excelforum.com/attachment...9&d=1456057518

Please Login or Register  to view this content.

Sorry about that!

http://www.excelforum.com/excel-prog...ss-memory.html

Hope that one works?