Worksheet.Copy Method (Object, Object)

 

Copies the worksheet to another location in the workbook.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

void Copy(
	object Before,
	object After
)

Parameters

Before
Type: System.Object

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

After
Type: System.Object

The sheet after which the copied sheet will be placed. You cannot specify After if you specify Before.

The new worksheet is a Microsoft.Office.Interop.Excel.Worksheet object and does not have the code or data binding capability that Microsoft.Office.Tools.Excel.Worksheet host items have.

If you do not specify either Before or After, Microsoft Office Excel creates a new workbook that contains the copied sheet.

For information on optional parameters, see Optional Parameters in Office Solutions.

Return to top
Show: