'Declaration
 
Public Shared Sub MoveTo( _
   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.MoveTo(source, sourceRow, sourceColumn, dest, destRow, destColumn, rowCount, columnCount, copyOption)

public static void MoveTo( 
   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.

Target Platforms: Windows Server 2012, Windows RT

Reference

Workbook Class
Workbook Members