Equivalent to clicking the Move or Copy Sheet command on the Edit menu. Moves one or more sheets between workbooks or changes a sheet's position within a workbook.
Syntax
WORKBOOK.MOVE(name_array, dest_book, position_num)
WORKBOOK.MOVE?(name_array, dest_book, position_num)
Name_array is the name of a sheet or an array of names of sheets in the active workbook that you want to move.
Dest_book is the name of the workbook to which you want to move name_array. If dest_book is omitted, WORKBOOK.MOVE moves the sheet out of the workbook and puts it in a new separate workbook. If dest_book is the same as the current book, then the sheet is moved within the workbook.
Position_num is a number that specifies the target position for the sheet within dest_book. The first position is 1.
If position_num is specified, Microsoft Excel inserts the sheet at the specified position in the workbook.
If position_num is omitted, Microsoft Excel moves the sheet to the last position in the workbook. If you move the last sheet out of a workbook, the workbook closes.
Related Function
WORKBOOK.COPY Copies one or more documents from their current workbook into another workbook
Return to index