Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using .copy to copy a worksheet several times
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using .copy to copy a worksheet several times
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. "Tonya" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using .copy to copy a worksheet several times
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Robert Flanagan" wrote: 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. "Tonya" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using .copy to copy a worksheet several times
See
http://support.microsoft.com/kb/210684/en-us -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ryguy7272" wrote in message ... 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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Robert Flanagan" wrote: 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. "Tonya" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'move or copy' a single worksheet multiple times | Excel Discussion (Misc queries) | |||
copy a worksheet to new one with repeat rows 5 times | Excel Discussion (Misc queries) | |||
copy worksheet multiple times base on user's input | Excel Worksheet Functions | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming |