0 out of 2 rated this helpful - Rate this topic

Sheets.Copy Method

Office 2003

Copies 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.Copy(Before, After)

Copy

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

Copy

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

Copy

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

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

After: Optional Object. The sheet after which the copied 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 copied 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