• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding a new workbook with set number of sheets

Marc L

Excel Ninja
So according to the VBA help use the Worksheets.Add method with its Count parameter or you can update​
the SheetsInNewWorkbook property (to see in VBA help like in threads of this forum) before creating a new workbook.​


Well-Known Member
Instead of:
Set WSNew = Workbooks.Add(xlWBATWorksheet).Worksheets(1)
SINWOrig = Application.SheetsInNewWorkbook 'store current setting
Application.SheetsInNewWorkbook = 4 'change setting
Set WSNew = Workbooks.Add.Worksheets(1) 'add workbook
Application.SheetsInNewWorkbook = SINWOrig 'restore setting to original