Out Of Memory

Could be caused by a number of different reasons
Check that you have not got a "hidden" instance of the Office application running.
Maybe you are running an infinite loop in your code

Solution

Close all instances
Export all the code to a folder
Save and close the workbook
Import all your code
Recompile and save