Number of Tabs in a workbook

[hall.jeff]

I know that excel 2003 has no specific upper limit (that I can find...
the old '95 limit of 255 is gone as I'm looking at one with over 1000
right now)

my problem is that I've got two worksheets that should be identical
copies of eachother

one is allowing me to add 37 extra tabs (copies of a current tab)
one allows me to add 30 extra tabs(again, copies of the same tab)

when I try to copy a new tab through code, I get a copy method of
class failed
when I try to copy a new tab by hand it silently fails (i.e. no error
message)

any advice on the cause and a possible work around would be helpful

thanks

 

[hall.jeff]

I know that excel 2003 has no specific upper limit (that I can find...
the old '95 limit of 255 is gone as I'm looking at one with over 1000
right now)

my problem is that I've got two worksheets that should be identical
copies of eachother

one is allowing me to add 37 extra tabs (copies of a current tab)
one allows me to add 30 extra tabs(again, copies of the same tab)

when I try to copy a new tab through code, I get a copy method of
class failed
when I try to copy a new tab by hand it silently fails (i.e. no error
message)

any advice on the cause and a possible work around would be helpful

thanks

http://support.microsoft.com/kb/210684 turned out to be microsoft's
solution... apparently it's a known problem in excel 2003 and 2007 and
97... I'm dying to know why this hasn't been fixed (wasn't xl2007
supposed to be a full rewrite of the code? how did this bug persist?)