On occasion I get an Out of Memory error in 2007. It seems to come up the most when I'm saving a file or closing Excel, but not exclusively at that time. Every file that I'm saving is saved fine. It happens with different files, so I have a hard time believing that it's in a file.
When I restart 2007 and reopen the files that were open everything is fine. I don't close anything or any other change to my system, only restart 2007. It does seem to happen more often as I increase the size of the file I'm working in, but when I restart 2007 and reopen the files, everything works fine.
My 1st thought was that there is some sort of memory leak in 2007, that Excel doesn't release memory when it's done with it. This was a problem with my database programming. Since I'm constantly adding code to modules, that makes the most sense to me, but I don't see that listed as a possibility in Help.
I have looked in Help and I'm tentatively reaching the conclusion that I'm hitting a 64 K boundary. Is there any way to determine how I'm hitting the boundary, and what I can do about it?
My only other thought is that one of the modules in my personal file is too large, but my largest module is only 987 lines, and it doesn't happen every time, so it's hard to believe that my personal module is too large.
Bookmarks