How to fix Run-time error 7 Out of memory in Excel Macro There are a number of fixes that you can implement to get rid of the out-of-memory runtime error in Excel VBA.