WORKBOOK.ADD

Macro Sheets Only

Equivalent to choosing the Add button on the workbook contents window in Microsoft Excel version 4. Moves a sheet between workbooks. For Microsoft Excel version 5.0 or later use WORKBOOK.MOVE.

Syntax

WORKBOOK.ADD(name_array, dest_book, position_num)
WORKBOOK.ADD?(name_array, dest_book, position_num)

Name_array is the name of a sheet, or an array of names of sheets, that you want to move.

Dest_book is the name of the workbook to which you want to add name_array. If dest_book is omitted, it is assumed to be the active workbook.

Position_num is a number that specifies the position of the document within the workbook.

Related Function

WORKBOOK.MOVE Moves one or more sheets between workbooks or changes a sheet's position within a workbook

WORKBOOK.COPY Copies one or more documents from their current workbook to another workbook

List of Command-Equivalent Functions