Memory Leak

  • Thread starter Thread starter GSS
  • Start date Start date
G

GSS

I'm opening 5 workbooks, and copying in sheets from each
workbook. After 5 iterations I get "copy method of
worksheet class failed" on the copy command. I monitored
application.memoryused. The number starts at around
450,000, jumps to 2,900,000, and climbs from there.

The best solution that TechNet provides is to close the
application frequently, to avoid running out of memory.
Any better solutions? Thanx!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memory Management 2
using .copy to copy a worksheet several times 3
Memory Leak 5
That "out of memory" error 2
Macro to copy sheets to another workbook fails after about 45 copi 3
Code copies twice...? 13
Maximum number of worksheets in Excel 2003 1
Copying a sheet fails 2

Back
Top