Copying/Renaming Sheets (Excel 2000)
Posted by T.Y. on April 24, 2001 12:42 PM
Please help me with this little annoying problem that I got when I upgraded from '97 to the 2000 version.
My problem is when I copy and rename an existing worksheet, I could only get between 30-45 sheets. This happens whether I copy one sheet at time or multiple sheets with vb codes. So far my only workaround is to save my workbook, exit Excel, then repon the workbook in order to create the next batch of sheets.
Thanks in advance for any help that you can give...!