using .copy to copy a worksheet several times

[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.

 

[Robert Flanagan]

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.

 

[ryguy7272]

Perhaps there is a memory leak due to bad coding. Check this for several
Copy/Paste/Merge examples:
http://www.rondebruin.nl/tips.htm

HTH,
Ryan---

 

[Ron de Bruin]

See
http://support.microsoft.com/kb/210684/en-us



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm