LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default That "out of memory" error

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
The Instruction at "0x749860a0" referenced memory at "0x00000000" Tribeca Excel Discussion (Misc queries) 1 July 5th 08 12:41 AM
Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B sebastienm Excel Programming 0 July 24th 04 08:35 AM
Getting "compile error" "method or data member not found" on reinstall Bp Excel Programming 1 April 23rd 04 04:42 PM
too many external links give "Not Enough Memory" error lothario[_67_] Excel Programming 0 January 13th 04 04:03 AM
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc Angus Comber[_2_] Excel Programming 1 November 7th 03 01:18 PM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"