Discussion Locked

Maximum Amount of Excel Worksheets

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone out there know the maximum amount of worksheets that can be added to a workbook?

5 replies

by tclere

I am not sure what the published value is, but if you go to the VB editor, add a module, add this code, and run the macro, you can find out:

Sub Macro1()
Dim i As Long
For i = 1 To 32000
Sheets.Add
Next i
End Sub

Themacro will error when no more sheets can be added.

I ran it for a little while, getting 730 sheets without a problem. NOTE: Even with empty sheets, this file was 1.28MB.

by pvp

It wouldn't suprise me if 32000 weren't high enough.

The highest number of sheets in a new book can be set is 255. Inserting another sheet was no problem. Doubled and doubled to 1024 with no problem.

Incidentally, if you shift and select a range of sheets, then click Insert->Worksheet, you'll that many new sheets.

This discussion is closed to new replies.