BetTheFarm
New Member
- Joined
- Jun 5, 2008
- Messages
- 1
Hello,
I've got a relatively lengthy VBA Excel macro that accomplishes it's goal - mainly range manipulation. The problem is that each time I execute the macro, it takes about 5% longer than the time before (I thought it was my imagination, but I used a timer to verify).
Each time I run the macro, it is not adding more cells to the spreadsheet, just replacing them with identical formulas (i.e., a "refresh"). Is there a cache that is filling up? Can I reset it?
Interestingly, if I save and close the workbook, reopen and excecute the macro, it runs quickly again the first time and then becomes progressively slower.
I'm confused! Thanks for any advice you may have...
I've got a relatively lengthy VBA Excel macro that accomplishes it's goal - mainly range manipulation. The problem is that each time I execute the macro, it takes about 5% longer than the time before (I thought it was my imagination, but I used a timer to verify).
Each time I run the macro, it is not adding more cells to the spreadsheet, just replacing them with identical formulas (i.e., a "refresh"). Is there a cache that is filling up? Can I reset it?
Interestingly, if I save and close the workbook, reopen and excecute the macro, it runs quickly again the first time and then becomes progressively slower.
I'm confused! Thanks for any advice you may have...