Reference>IXLSWorksheet>Move

Moves the sheet to another location in the workbook.

Syntax

procedure Move(Before: IXLSWorkSheet; After: IXLSWorkSheet; lcid: integer);

procedure Move(Before: IXLSWorkSheet; After: IXLSWorkSheet);

procedure Move(Before: IXLSWorkSheet);

Before	IXLSWorkSheet. The sheet before which the moved sheet will be placed. You cannot specify Before if you specify After.
After	IXLSWorkSheet. The sheet after which the moved sheet will be placed. You cannot specify After if you specify Before.
lcid	Integer. The locale ID.

This example moves the first sheet after the third sheet in the workbook.

Workbook.Sheets[1].Move(nil, Workbook.Sheets[3]);

This example moves the second sheet before the first sheet in the workbook.

Workbook.Sheets[2].Move(Workbook.Sheets[1]);