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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADDING/DELETING SHEETS WITHOUT LOSING FOCUS. 6
couple subs I need help with 1
Macro that adds up the sheets of similar workbooks 3
Create a workbook from every worksheet in your workbook 7
Export Sheet Values to new workbook 20
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
UDF FOR DEPENDENTS 5
Excel shortcut options 0

Back
Top