MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?



Posted by neo on August 21, 2001 2:28 PM

the only thing i can think of is you're confusing 'memory' with hard drive space. memory is RAM, and each MB of RAM can handle only so much information. most machines use 64-128MB of RAM and that's not enough to support the number of sheets you're trying to create. honestly, i couldn't tell you how much RAM you'd need to do what you're trying to do. maybe a few 512MB sticks would, but even then...