Set No of Sheets in new workbook

[cornishbloke]

Hopefully a quickie for someone

When using the VBA code:

workbooks.add

how do I determine the number of sheets in that newly created workboo
(i.e rather than using the value set in excel's options on eac
individual pc)

 

[shades]

Application.SheetsInNewWorkbook = 5

Change the number to suit your purposes.

 

[cornishbloke]

exactly what I was looking for, thanks!

 

[Bob Phillips]

Workbooks.Add
cSheets = ActiveWorkbook.Worksheets.Count

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)