none
Error 7 out of memory solution RRS feed

  • Question

  • Hi someone Knows if I change the virtual memory of my pc, this can help me to fix the error 7 "excel out of memory", or any body knows how I can fix this error Im using this code

    Range("A1:AE10131").value = workbooks(NameWB).Sheets(WS).("A1:AE10131").value

    thanks for your time.

    Friday, December 5, 2014 8:24 PM

Answers

  • Hi Alejsv,

    Please try to use the Copy method of Range instead of assigning the value directly to another range. There should be a very large amount of data in this range.

    Another way is to use foreach statement to loop though all the rows and assign the row values to the row of the new worksheet. This should be a workable solution. But it may take  a long time since there're over ten thousand rows in there.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, December 8, 2014 6:57 AM
    Moderator