How many worksheet can workbook have

[JB]

What is the limit number of worksheet can a workbook have?

[Chip Pearson]

There is no hard and fast limit. The number depends on available
memory.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JB" <[email protected]> wrote in message
news:[email protected]...
> What is the limit number of worksheet can a workbook have?

[Andy Wiggins]

A new workbook can have a maximum of 255 sheets, but after that you can go
on adding sheets until your memory runs out.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"JB" <[email protected]> wrote in message
news:[email protected]...
> What is the limit number of worksheet can a workbook have?