CopyTo Method (Workbook)

Copies data from one range to another.

Syntax

Visual Basic
C#

'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.

Reference

Workbook Class
Workbook Members