Maximum # of worksheets in workbook

[Guest]

Hey Gang,

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

 

[papou]

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

HTH
Cordially
Pascal

Hey Gang,

Anybody know if there is a limit on the number of worksheets you can

create in a single workbook?

 

[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

worksheets you can create in a single workbook?

 

[Jan Karel Pieterse]

Hi Rlo,

There is a max of 256 worksheets per workbook.

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

 

[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"

 

[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