memory leak

I need to run (a variant of) this module a few hundred times. After a few times (2 to 5) I get an error "insufficient memory". Anybody any idea how to fix this? Sub testertje() Dim WBmodel As Workbook Dim WSscan As Worksheet Dim pad As String pad =...

Hello all, I'm having an issue, which I found is quite common (nevertheless, I haven't found an answer for it). Basically, I'm trying to add new rows (5 new rows, to be specific) on top of a table I previously created and formatted. When I try to insert new rows, Excel crashes and gives me...

Good afternoon, I am working with a large spreadsheet that makes use of an equally large number of pivot tables. Currently the sheet has 231 pivot tables, 228 of which are all referencing the same data source. That data source is also, not surprisingly, large. The data source covers 90...

I have created an automated macro which takes vehicle crash data from a csv file and automatically creates pivot table,charts and compares it to the previous year. The code is approximately 1400 lines long and the data of the uploaded csv can be anywhere between 2 to 100 mb csv files with more...

The following code results in a huge jump in memory (that isn't released once its run) even though there is only 2 Integer variables and 1 String variable. Its a simplified version of some 'real code' which makes VBA run out of memory and crash. Any ideas what's going on and how to resolve? Sub...

Hello, I have an Excel file that is larger in size than it 'should' be. The file is a simple template that is placed on a network drive and updated by between 2-3 dozen people on a daily basis. It's 14 sheets, but should only have about 20 rows and 10 columns of data per sheet. When the...

Hi All. I have a workbook with lots of macros. When I save the workbook either via code or manually I get a memory leak of between 10mb and 100mb (i.e. the memory usage increases by 10mb to 100mb each time). Has anyone else encountered this? I'm assuming it's not normal because, at that rate...

I have a workbook with a lot of userforms, modules, OLE objects. 6.4 Mb file size. I have successfully used the same template over and over. Now i have one template that shows calculate in the status bar every time a cell is selected. Nothing is even changed. When i update a cell value, cpu...

Good Day, Something weird is happening… I’ve a rather large program that I’ve broken up into little mod’s. During an early phase of breaking things up I needed to reduce memory. In an effort to reduce memory, I put things like Set ws=nothing Set msformz=nothing Set msbuttonz=nothing ---I did...