Max. sheets in workbook?

[khickey]

Does anyone know the maximum number of sheets a workbook can contain? (Excel 2000)

Cheers

 

[Jack in the UK]

this has now real limit bat will crash if to many that you pc cant hadle.

all down to resorce allocation what is counter balanced but OP system v's and version of Excel applications running and the power resources the pc has.

NT Technoligies willperforme best as they can counter the didty memory issues in superior mannmo rto domestic windows..

just to keep it simple ill stop there let me know if you need more

 

[Jay Petrulis]

Hi,

This is limited by the amount of available memory. I think the maximum number if sheets in a default workbook is 255.

You can keep adding sheets until your computer quits.

Jay

 

[khickey]

Thanks guys. I am running Win2000 and have heaps of memory.... I'll just keep adding sheets and see what happens!!!

 

[Jack in the UK]

Win 200 nice if excel 2000 or poss XP, i would go good for hundreds, but REMENMBER back up always so no crying later

if sheets are light more is nasty heavy and book size over 5mb be careful... 10mb NASTY....

just some points... i always keep excel light and good looking after all she fancys me if im good to her, and im ugly!

 

[Jay Petrulis]

Hi,

Try this and keep doing it until Excel crashes, if you want a fast way to test your system

Sub New_Sheets()
Dim intNumber As Integer, Counter As Integer
intNumber = _
Application.InputBox("Create how many sheets?", "Number of new sheets", "300")

Application.ScreenUpdating = False
For Counter = 1 To intNumber
Worksheets.Add
Next
Application.ScreenUpdating = True
End Sub