1
I am making a spreadsheet, and whenever I run my macros it starts to crash, I saw how much of Ram ta using and ta 1.6GB and the file each time it saves increases significantly in size, now it is 350mb. Only in this spreadsheet I do not add new data, I overwrite the old ones only.
Is there any way to put the code you use? You are probably saving many items in memory
– PauloHDSousa
There are some tricks to reduce memory usage, such as taking out the view, separating functions with many lines, segregating the code to use classes, but you would have to see the code to give some hint. If you can post the code that is generating this large amount of memory usage that surely someone can help.
– Evert