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.
Trending Software posts
Sort by Trending