When running a program with many iterations that creates
183 worksheets and populates them with data obtained from
other workbooks, I get an "Out of Memory" message aftere
about 27 iterations.
Using the Application.MemoryTotal, MemoryUsed, MemoryFree
properties in a sub, I get the following figures:
Total: 2,908,064 bytes
Used: 1,897,064 bytes
Free: 1,048,576 bytes.
What can I do to either use less or create more total
memory? Can I clear memory (using code) after each
iteration? Or maybe through the Windows options?

Lionel