'Declaration
 
Public Shared Sub CopyTo( _
   ByVal source As Worksheet, _
   ByVal sourceRow As System.Integer, _
   ByVal sourceColumn As System.Integer, _
   ByVal dest As Worksheet, _
   ByVal destRow As System.Integer, _
   ByVal destColumn As System.Integer, _
   ByVal rowCount As System.Integer, _
   ByVal columnCount As System.Integer, _
   ByVal copyOption As CopyToOption _
) 

'Usage
 
Dim source As Worksheet
Dim sourceRow As System.Integer
Dim sourceColumn As System.Integer
Dim dest As Worksheet
Dim destRow As System.Integer
Dim destColumn As System.Integer
Dim rowCount As System.Integer
Dim columnCount As System.Integer
Dim copyOption As CopyToOption
 
Workbook.CopyTo(source, sourceRow, sourceColumn, dest, destRow, destColumn, rowCount, columnCount, copyOption)

public static void CopyTo( 
   Worksheet source,
   System.int sourceRow,
   System.int sourceColumn,
   Worksheet dest,
   System.int destRow,
   System.int destColumn,
   System.int rowCount,
   System.int columnCount,
   CopyToOption copyOption
)

Parameters

source

The source sheet.

sourceRow

The source row.

sourceColumn

The source column.

dest

The target sheet.

destRow

The target row.

destColumn

The target column.

rowCount

The row count.

columnCount

The column count.

copyOption

The copy option.

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Workbook Class
Workbook Members