using .copy to copy a worksheet several times

  • Thread starter Thread starter Tonya
  • Start date Start date
T

Tonya

I have a loop to load data into a worksheet, copy that worksheet into a
different workbook, and then do it again with the next set of data.
After over 50 itterations the copy sheet method fails.
What can I do? I need to run about 150 iterations. I want to use the .copy
so that the print formatting comes over.
 
Tonya, what verison of Excel are you using?

Try unchecking all add-ins you don't need. Too many add-ins can cause
memory problems. Also remove COM add-ins. If you need help on how to
remove, please reply to the group with your version of Excel.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


You may need more memory on your PC. How much do you have? Minimum for
2003 for me is 1GB and for Excel 2007 is 2GB. It can obviously run with far
less, but problems happen.
 
Back
Top