why is the name of sheet 411111111?
Posted by Karol on July 02, 2001 2:52 AM
In Excel 97 I copy a sheet in the same file through VBA
macro. Name of the new sheet in the active workbook is
date, but name of the sheet as a Microsoft Excel Object
is still *Sheet*. I´d expect that name of the new
object will be created like this:
original *Sheet4* copy, new sheet *Sheet5*
but the new sheet is named this way
original *Sheet4* copy, new sheet *Sheet41*
and if the original sheet is copying ten times, the name
of the tenth sheet is *Sheet41111111111*. After closing
the file and reopening the sheets´names are still
strange. This is serious problem because I can make
only about 30 sheets in the file this way.
If the file is saved as Excel 5.0/95 the objects´names
are O.K. but it will generate other problems with
the old spreadsheet format.
Is there any help, please?