Xceed Workbooks for .NET v1.4 Documentation
InsertRange(String,String,InsertRangeShiftType) Method


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace > Worksheet Class > InsertRange Method : InsertRange(String,String,InsertRangeShiftType) Method
The Address of the Cell that is currently located where the top left corner of the inserted range will be located.
The Address of the Cell that is currently located where the bottom right corner of the inserted range will be located.
Specifies the InsertRangeShiftType.
Inserts an empty CellRange using Cell Addresses to identify where the range will be inserted and allows to specify in which direction the Cells located after the inserted range will be shifted.
Syntax
'Declaration

 

Public Overloads Sub InsertRange( _

   ByVal startingCellAddress As String, _

   ByVal endingCellAddress As String, _

   ByVal shiftType As InsertRangeShiftType _

) 
'Usage

 

Dim instance As Worksheet

Dim startingCellAddress As String

Dim endingCellAddress As String

Dim shiftType As InsertRangeShiftType

 

instance.InsertRange(startingCellAddress, endingCellAddress, shiftType)

Parameters

startingCellAddress
The Address of the Cell that is currently located where the top left corner of the inserted range will be located.
endingCellAddress
The Address of the Cell that is currently located where the bottom right corner of the inserted range will be located.
shiftType
Specifies the InsertRangeShiftType.
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

See Also

Reference

Worksheet Class
Worksheet Members
Overload List