Home ยป Range.Insert method
Learn
Excel Macro: Insert Blank Rows Between Existing Rows
If you need to insert blank rows between each of the existing rows into your Worksheet with VBA, this macro will help you to do this.
Docs
Range.Insert method
Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space. […]