Worksheet Copy limitation???

[amigos]

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!

 

[GlennUK]

Look in the VBE at the internal sheet names ... your trouble might be there.

 

[erik.van.geit]

Hello,
would an alternative be to copy directly the sheet to a new workbook ?

Sheets("yoursheet").Copy

best regards,
Erik

 

[amigos]

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]

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]

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