Insert multiple rows using VBA in Excel
This video will outline one way, via Visual Basic for Applications or VBA, to insert multiple rows simultaneously into an Excel worksheet.
Presently Excel only allows users to insert one row at a time.
Excel VBA will give us the capacity to choose and insert numerous rows simultaneously.