Insert a Row
Inserts a row into an existing Excel worksheet.
Overview
This procedure inserts a new row into an existing Excel worksheet at a specified row number. Existing rows are shifted down. This allows you to add rows without overwriting existing content in the worksheet.
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
Examples
1. Insert a Row by Specifying a Row Number
insert a row into the worksheet where
the row number is 2
2. Insert a Row by Specifying a Row Number and Values
insert a row into the worksheet where
the row number is 2
the values are "Earth", "Water", "Fire", "Air"
Last updated
Was this helpful?