'Declaration

 

Public Sub InsertRows( _

   ByVal rowId As Integer, _

   Optional ByVal count As Integer _

) 

'Usage

 

Dim instance As Worksheet

Dim rowId As Integer

Dim count As Integer

 

instance.InsertRows(rowId, count)

public void InsertRows( 

   int rowId,

   int count

)

Parameters

rowId

The Id of the Row that is currently located where the new Rows will be inserted. The Ids start at 0.

count

The number of Rows that will be inserted. The default value is 1.

As in Microsoft Excel, the newly inserted Rows will have the same Style as the Row that precedes the insertion point.

All the Rows that follow the insertion point will also be shifted down to leave some place for the newly inserted Rows.

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

Worksheet Class
Worksheet Members