This topic has not yet been rated - Rate this topic

Sheets.Move Method

Office 2003

Moves the sheet to another location in the workbook.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Copy

'Usage
Dim Before As Object
Dim After As Object
Dim sheets1 As Sheets
sheets1.Move(Before, After)

Copy

void Move(
	[In, Optional] object Before, 
	[In, Optional] object After
);

Copy

public void Move(
	/*in*/System.Object Before, 
	/*in*/System.Object After
);

Copy

function Move(
	 Before : Object, 
	 After : Object
);

Before: Optional Object. The sheet before which the moved sheet will be placed. You cannot specify Before if you specify After.

After: Optional Object. The sheet after which the moved sheet will be placed. You cannot specify After if you specify Before.

If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the moved sheet.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ