VBA Error 7: Out of memory

Cause:  More memory is required than is available.

Solution:

To correct this error:
•Close unnecessary applications, documents and source files.
•Eliminate unnecessary controls and forms so fewer are loaded at one time
•Reduce the number of Public variables.
•Check available disk space.
•Increase the available RAM by installing additional memory or reallocating memory.
•Make sure that memory is freed when it is no longer needed.