Move(Worksheet,Worksheet) Method

Moves a specific Worksheet into a WorksheetCollection and targets another Worksheet as the insertion point.

Syntax

Visual Basic
C#

'Declaration

 

Public Overloads Sub Move( _

   ByVal sourceWorksheet As Worksheet, _

   ByVal destinationWorksheet As Worksheet _

)

'Usage

 

Dim instance As WorksheetCollection

Dim sourceWorksheet As Worksheet

Dim destinationWorksheet As Worksheet

 

instance.Move(sourceWorksheet, destinationWorksheet)

public void Move( 

   Worksheet sourceWorksheet,

   Worksheet destinationWorksheet

)

Parameters

sourceWorksheet: The Worksheet that will be moved.
destinationWorksheet: The Worksheet that is currently located where the selected Worksheet will be moved.

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

WorksheetCollection Class
WorksheetCollection Members
Overload List