ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   worksheet limit (https://www.excelbanter.com/excel-programming/330184-worksheet-limit.html)

sali

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