Is there really a 255 worksheet limit in Excel?

[Merz]

I need to put into production a workbook with 400+ worksheets, which I can create, but I’m worried about compatibility issues as several places online mention this 255 number.

[administrator@dailyexcel.net]

Excel does not limit the number of worksheets!

For example, you can create 1000 worksheets using the following VBA code:

Sub AddSheets()

Dim n As Integer

For n = 2 To 1000

Sheets.Add(After:=Sheets("Sheet" & n - 1 )).Name = "Sheet" & n

Next n

End Sub

This number probably comes from the limits imposed by other (legacy) software, i.e. Lotus, OpenOffice etc.

[Author]

Posts