Macro command AddSheets

<< Click to Display Table of Contents >>

Navigation:  Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel >

Macro command AddSheets

Purpose:

Expands the number of worksheets in an Excel workbook.

 

General notation:

Addsheets ( FileIndex, number )

 

Example:

Add 3 worksheets to the Excel workbook 1.

 Addsheets ( 1, 3 )