WORKBOOK.COPY

Macro Sheets Only

Equivalent to choosing the Move or Copy Sheet command from the Edit menu. Copies one or more sheets from their current positions to the specified position in the same workbook or to another workbook.

Syntax

WORKBOOK.COPY(name_array, dest_book, position_num)
WORKBOOK.COPY?(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 copy in the currently active workbook.

Dest_book is the name of the workbook to which you want to copy name_array. If dest_book is the current workbook, name_array is copied within the workbook. If dest_book is omitted, the copy of name_array becomes a separate workbook.

Position_num is a number that specifies the target position for the sheet within the new workbook. The first position is 1.

• If position_num is specified, Microsoft Excel inserts the copy of the sheet at the specified position in the workbook.
• If position_num is omitted, Microsoft Excel places the sheet at the last position in the workbook.
• If dest_book is omitted, position_num is ignored.

Remarks

• If the structure of the workbook is protected, you cannot copy sheets within the workbook or to another workbook.
• You cannot copy a hidden sheet.

Related Function

WORKBOOK.MOVE Moves one or more documents from one workbook to another workbook or to another position in the same workbook

List of Command-Equivalent Functions