![]() ![]() I was wondering, maybe there's some trick I could implement between the columns to make Excel forget whatever it keeps remembering? I don't really care if it will hit performance (in case it has cached anything useful for further calculations), I just need to keep memory usage from growing too huge to process. I've reached a point where I can't process all the columns I need on a 32 bit Excel due to memory limit. After I close and reopen the file - all memory is, of course, freed and I can continue to work. With each column memory used by Excel increases significantly and after the macro is done and I save the file - the memory is still used (if I can trust Task Manager). Once I cycled through the row I do Range.Value = Range.Value twice to execute the formulas and to save result as value. I cycle through rows in one column, assigning pretty big SUMPRODUCT functions to the cells without executing them. I have a macro for Excel, nothing too fancy, no objects, just plain old cycles with formulas. PatricK PatricK Not the answer you're looking for? Browse other questions tagged vbacoreldraw or ask your own question.
0 Comments
Leave a Reply. |