Maximum # of worksheets in workbook

N

nik59

Hey Gang,

Anybody know if there is a limit on the number of worksheets you can create in a single workbook?
 
P

papou

Hi nik59
Like some other features with Excel this is limited by the available memory
on your system.

HTH
Cordially
Pascal

nik59 said:
Hey Gang,

Anybody know if there is a limit on the number of worksheets you can
Click to expand...
create in a single workbook?
 
R

rlo

There is a max of 256 worksheets per workbook.
-----Original Message-----
Hey Gang,

Anybody know if there is a limit on the number of
Click to expand...
worksheets you can create in a single workbook?
 
J

Jan Karel Pieterse

Hi Rlo,
There is a max of 256 worksheets per workbook.
Click to expand...

Nope, number of worksheets depends on available resources.
This code happily adds 300 sheets (Excel XP):

Sub test()
Dim i As Integer
For i = 1 To 300
ThisWorkbook.Worksheets.Add
Next
End Sub


Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
A

Andy Wiggins

See Papou's reply - the number's limited by available memory.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
G

Gord Dibben

rlo

The default number of sheets in a new workbook(Tools>Options>General "sheets
in a new workbook" is maxed at 255, but you can add more once the workbook is
open.

Gord Dibben Excel MVP
 
Top