'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