CopyTo Method (Workbook)

In This Topic

Copies data from one range to another.

Syntax

Visual Basic
C#

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

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

public static void CopyTo( 
   Worksheet source,
   int sourceRow,
   int sourceColumn,
   Worksheet dest,
   int destRow,
   int destColumn,
   int rowCount,
   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