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" wrote in message
...
What is the limit number of worksheet can a workbook have?