Split this up over different workbooks or sheets.

This is the same issue as your previous post: http://www.excelforum.com/excel-prog...e-of-code.html

Yes, it is possible to use one set of code to create additional workbooks and insert data. However, it creates the new workbook(s) in the same instance of Excel.exe running on your system. Therefore, you will still hit the 1.5GB memory limit with this task and generate the error. You're creating a SERIOUS amount of data with this nested loop. Since .xlsx/.xlsm files are really just compressed (zipped) files of xml data, the 98MB file actually decompresses upon launch and uses 800MB+ of memory. The same applies to the second workbook I showed you how to create, although it's slightly smaller when compressed and decompressed. We're still talking 1.4-1.5GB of memory just having both open and not doing anything with them.

I do have one serious question for you -- why, if I've shown you how to generate the list once over the span of two workbooks, would you EVER need to create such a list again?? Once you have such a list it's there for good. Create copies of it if you want to make changes, keeping the original intact.

If you really want to generate this list in one (or even two) workbooks at the same time, I'd suggest getting a 64-bit PC and 64-bit version of Excel. From what I've read it will be able to handle the memory requirements. (Or find someone who knows how to use VBA to clear memory from an active Windows process during runtime in 32-bit.)