ExcelBanter - Max Number of Sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Max Number of Sheets (https://www.excelbanter.com/excel-programming/279879-max-number-sheets.html)

Wendy[_3_]

Max Number of Sheets

Does anyone know if there is a max number of sheets you can add to a
workbook???

Wendy

Pete McCosh[_5_]

Max Number of Sheets

Wendy,

according to the help there is no defined limit, it's
driven by the available memory. Lots of sheets with not
much on them or not so many with a lot on them!

Pete
-----Original Message-----
Does anyone know if there is a max number of sheets you
can add to a
workbook???

Wendy

.

Ron de Bruin

Max Number of Sheets

Hi Wendy

The maximum number of sheets in a workbook is limited by available memory.
The max number of sheets that can, by default, be in a newly created
workbook is 255

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"Wendy" wrote in message .. .
Does anyone know if there is a max number of sheets you can add to a
workbook???

Wendy

Tom Ogilvy

Max Number of Sheets

you are only limited by memory. There is a maximum of 256 when you create a
new workbook, but you can add more after it is created.

--
Regards,
Tom Ogilvy

"Wendy" wrote in message
.. .
Does anyone know if there is a max number of sheets you can add to a
workbook???

Wendy

All times are GMT +1. The time now is 01:06 AM.