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
|