Dear Experts,
Leith Ross, Mudraker, VoG, and many others have helped me a great deal when I started out with VBA beginning 2008. I have custom created a production planning and sceduling program for a company. The workbook contains about 14 Sheets, is about 11MB and works very well. However, I suspect that some memory build-up is taking place somewhere, since the performance seems to slow down after a few months. There are no pivot tables, "solvers" or loops. Data just passes through without any serious build up of same. Could it be that in an obscure place somewhere some activities of the workbook are stored that could ultimately affect the performance? Just wondering![]()
Bookmarks