I have a macro that depending on the setting can create/delete up to 35 worksheets per run. I noticed that after only a handful of runs, it becomes EXTREMELY slow. If I close it and reopen it, it reverts back to top speed. Is there a way to simulate whatever is being dumped when I close it to maintain top speed?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Too many sheets created slows things down
- Thread starter jrnyman
- Start date
Similar threads
- Question
- Solved
