Error 400 Out of memory

Hey!

I've got an Excel workbook running on an office screen that shows numbers from different departments.
The macro part is simply "auto updating" the numbers so the screen can run without any human interaction.

A problem with this is that after running for a few weeks it "runs out of memory"?
I've tried having the temporary Excel files deleted once in a while, but it does not appear to affect this memory it is running out of.
The only solution I've found is to close the entire Excel application and restart the workbook.

Does anyone here have any idea of solution to how I could "empty" the Excel memory so the workbook macro can keep running ~forever?

Thank you in advance!

How are you releasing objects in your code? Can you post it here?
A few other things to look at https://www.automateexcel.com/vba/out-of-memory-error/

I'm not sure if I use any objects. This is the "timer" code I use to refresh the data:

Please Login or Register  to view this content.

This is the refresh code that runs when the timer reaches 300:

Please Login or Register  to view this content.

To not keep referenses I use this to translate the referenses to text:

Please Login or Register  to view this content.

This is one of my attempts to lessen the memory usage by closing open workbooks, but it does not seem to have made any difference.

Please Login or Register  to view this content.

I do not know if any of these counts as objects. I do not use any graphical objects. Only text.

Anything you use Set with is an object. How is rng, Workbooks given a values? The timer stuff can be rough too. Also, the size of the Excel file and the calculations it has to carry out will impact this.