New WorkBook With Specified Number of Sheets

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

Sure would oblige if the proper complete syntax is provided in respect of
Creating a New Workbook with a specified number of sheets.

Thanx in advance!
 
Sure would oblige if the proper complete syntax is provided in respect of
Creating a New Workbook with a specified number of sheets.

Thanx in advance!
Click to expand...

Hello.

One way is:

Sub newworkbook()
pastsheets = Application.SheetsInNewWorkbook
newsheets = 3
Application.SheetsInNewWorkbook = newsheets
Workbooks.Add
Application.SheetsInNewWorkbook = pastsheets

End Sub

Regards,

Benito
Barcelona
 
Back
Top