Cannot create a new worksheet
Posted by Christopher Patrick on August 21, 2001 12:44 PM
I am trying to create multiple new worksheets via a macro I have written, and I am finding that I cannot create more than 259 worksheets...I am attempting to create 1000 for this project. The help states there are only memory limits to the number of worksheets a workbook contains, and I have checked and have enough memory to create new worksheets, but each time I attempt this, the screen blinks, and nothing happens. Can anyone explain what may be the problem?