P105 Move Sheet Location within Workbook

 

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

105

Move sheet location within workbook.

/1 = sSheetToMove (by name or by number)

/2 = sSheetBefore (by name or by number)

/3 = sSheetAfter (by name or by number)

This special process can move a worksheet within the same workbook.

Special Parameters Described in Detail

/1{sSheetToMove} Name of the sheet to Move. Required.

/2{sSheetBefore} Moved sheet will be placed before this sheet (Name or #). If sSheetBefore = "firstfirst" then it is placed as the first sheet in the workbook.

/3{sSheetAfter} Moved sheet will be placed after this sheet (Name or #). If sSheetAfter = "lastlast" then it is placed as the last sheet

Additional Notes: Only sSheetBefore, or sSheetAfter should be specified, not both. If neither the sSheetBefore, nor the sSheetAfter have been specified then the new sheet will be the last sheet.

Examples:

EXAMPLE 1 Move a worksheet to before a specified sheet

EXAMPLE 2 Move a worksheet to be the first sheet