New WorkBook With Specified Number of Sheets
 

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!
--
Best Regards,

Faraz

New WorkBook With Specified Number of Sheets
 

On 15 dic, 11:23, Faraz A. Qureshi
wrote:
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!
--
Best Regards,

Faraz

Hello.

One way is:

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

End Sub

Regards,

Benito
Barcelona