Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheets in workbook limit?
I have routine that updates previous workbooks by copying sheets within the
new workbook and getting the old sheet information. Everything works great, but for some reason after more than 45 sheets are copied it errors out. Some of my workbooks contain over 100 sheets. Is this a memory thing or limit thing? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheets in workbook limit?
Hi Gary
See Copying Worksheet Programmatically Causes Run-Time Error 1004 http://support.microsoft.com/default...84&Product=xlw -- Regards Ron de Bruin http://www.rondebruin.nl "Gary" wrote in message ... I have routine that updates previous workbooks by copying sheets within the new workbook and getting the old sheet information. Everything works great, but for some reason after more than 45 sheets are copied it errors out. Some of my workbooks contain over 100 sheets. Is this a memory thing or limit thing? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheets in workbook limit?
That did the trick. Thanx
"Ron de Bruin" wrote: Hi Gary See Copying Worksheet Programmatically Causes Run-Time Error 1004 http://support.microsoft.com/default...84&Product=xlw -- Regards Ron de Bruin http://www.rondebruin.nl "Gary" wrote in message ... I have routine that updates previous workbooks by copying sheets within the new workbook and getting the old sheet information. Everything works great, but for some reason after more than 45 sheets are copied it errors out. Some of my workbooks contain over 100 sheets. Is this a memory thing or limit thing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
want to share workbook but limit the sheets each user sees | Excel Worksheet Functions | |||
copying worksheets in a workbook limit? | Excel Worksheet Functions | |||
limit to copying rows in workbook? | Excel Programming | |||
How do I limit number of sheets in a Workbook? | Excel Programming | |||
Limit on number of Sheets in a Workbook? | Excel Programming |