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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Look in the VBE at the internal sheet names ... your trouble might be there.
 
Upvote 0
Hello,
would an alternative be to copy directly the sheet to a new workbook ?

Sheets("yoursheet").Copy

best regards,
Erik
 
Upvote 0
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!
 
Upvote 0
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 ).
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,212,096
Messages
6,105,942
Members
447,985
Latest member
gigi11

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
Back
Top