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?

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?

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?