none
EXCEL 2013 런타임 오류 '7' RRS feed

  • 질문

  • 안녕하세요.

    윈도우10 / 오피스 2013 Standard 사용 중입니다.

    정상적으로 수행했던 VBA 매크로 설정된 EXCEL 인데 작업 취소 후 재시작 시 아래와 같이 실패하고 있습니다.


    " '7' 런타임 오류가 발생하였습니다. 메모리가 부족합니다 "

    오류 당시 PC 메모리는 4.4/15.9 (28%) 사용 중이었습니다.

    답변 부탁드립니다.


    2019년 3월 5일 화요일 오전 7:56

모든 응답

  • https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/out-of-memory-error-7 문서 참조해서 확인해 보세요.

    More memory was required than is available, or a 64K segment boundary was encountered. This error has the following causes and solutions:

    • You have too many applications, documents, or source files open. Close any unnecessary applications, documents, or source files that are open.

    • You have a module or procedure that's too large. Break large modules or procedures into smaller ones. This doesn't save memory, but it can prevent hitting 64K segment boundaries.

    • You are running Microsoft Windows in standard mode. Restart Microsoft Windows in enhanced mode.

    • You are running Microsoft Windows in enhanced mode, but have run out of virtual memory. Increase virtual memory by freeing some disk space, or at least ensure that some space is available.

    • You have terminate-and-stay-resident programs running. Eliminate terminate-and-stay-resident programs.

    • You have many device drivers loaded. Eliminate unnecessary device drivers.

    • You have run out of space for Public variables. Reduce the number of  Public variables.

    • You have attempted to update a property that is read-only. Do not assign values to read-only properties.

    2019년 3월 11일 월요일 오전 12:49