Xceed Workbooks for .NET v2.0 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