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!
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!