Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Limit in Workbook Ron Excel Worksheet Functions 2 June 30th 09 07:41 PM
Limit Visibility of a worksheet Tdahlman Excel Discussion (Misc queries) 1 March 12th 08 04:13 PM
Worksheet Limit BillCPA Excel Discussion (Misc queries) 1 February 5th 06 05:19 AM
Worksheet Limit Jonathan Cooper Excel Discussion (Misc queries) 0 February 4th 06 08:07 PM
worksheet size limit long term user Links and Linking in Excel 2 January 30th 06 11:48 PM


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"