Worksheet Copy limitation???

amigos

Active Member
Joined
Sep 23, 2003
Messages
407
guys

that's weird

I have a code which creates a copy of main worksheet within the same workbook
does some staff with it (formats. paste as values etc.)
than moves it to new workbook and saves it - basically I need to be able to create 100 copies of the same worksheet (with small changes)

and after 78th sheet Excel refuses to copy that main sheet!

right click/move or copy...
ctrl and drag drop
.copy in VBA

they just dont work - basically nothing happends...

did you come across that before??

Thank you in advance!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Look in the VBE at the internal sheet names ... your trouble might be there.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hello,
would an alternative be to copy directly the sheet to a new workbook ?

Sheets("yoursheet").Copy

best regards,
Erik
 

amigos

Active Member
Joined
Sep 23, 2003
Messages
407
thanks for your responses

erik.van.geit: that's what I am trying to do now - copy somewhere else first and than make all changes

GlennUK: why would taht affect it?
I create a copy, rename it and move it to new workbook which I save and close
than again
create copy, ....

Thanks!
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Have you actually had a look? If you've been doing copy of a copy you'll probably see names like Sheet11111111111111. And when you get to a certain level Excel won't let you copy any more ( Excel 97 anyway ).
 

amigos

Active Member
Joined
Sep 23, 2003
Messages
407
original external name is Report
internal name is Seet1 (report)

when I create a copy
external is Report (2)
internal Sheet6 (Report(2))

than I rename it to be called London instead Report (2)

move it to other workbook

and when I repeat the proces again - names are just repeated...

I made a change to copy the sheet to external workbook at the begining and it works...

thank you
 

Watch MrExcel Video

Forum statistics

Threads
1,130,342
Messages
5,641,592
Members
417,224
Latest member
llama9207

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top