Thread: worksheet limit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sali sali is offline
external usenet poster
 
Posts: 53
Default 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?