Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have read many references to the "out of memory" error posted here.
But my problem seems to be slightly different. It is not a chart/font problem. Nor a multiple workbook or formula problem. Nor any of the many other problems related to this error. I am populating the cells in a new worksheet from a recordset. It is just text that I am adding. The cell that is being populated is the 306th iteration of a loop. The text in the cell is reasonably large at 1600 characters, but there are many more cells earlier in the loop that have similar or more characters (the largest being 2346 characters). I have found that if I populate the Cell with the first 1024 characters it will work, but 1025 characters gives the same message. I have checked task manager on the machine, and I am no where near reaching the limits of available RAM, so it is not a system memory problem (unless I have a memory leak). I have checked the "Application.MemoryUsed" and I am no where near the internal Excel stack maximum. I have tried sprinkling the code with ‘DoEvent's but this makes no difference. I am still googling, but does anyone have any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The Instruction at "0x749860a0" referenced memory at "0x00000000" | Excel Discussion (Misc queries) | |||
Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B | Excel Programming | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
too many external links give "Not Enough Memory" error | Excel Programming | |||
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc | Excel Programming |