![]() |
worksheet limit
what is the limit of umber of workshhets in one workbook.
somebody said it is limited only by system memory [so help says]? but excel2000 on w98/64mb breaks on 5300 sheets while excel2000 on xp/512mb breaks on 850 sheets code is: Sub listovi() Dim param As Variant, koliko As Integer, radni As Variant, _ i As Integer, ws As Variant Set param = ThisWorkbook.Sheets("param") koliko = param.Cells(1, 1).Value Set radni = ActiveWorkbook For i = 1 To koliko Set ws = radni.Worksheets.Add Next End Sub requested number of sheets to add is given on param sheet cell(1,1) of course, huge number of ws is not suitable for interactive editting, but i tried to organize some data by sheets, having each sheet only poorly populated, so overall file size would not be terrific. is there some advice how to estimate "free space" for worksheets adding? |
All times are GMT +1. The time now is 07:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com