add value from every nth row code example
Example: add specific amount of rows after row
Sub insertRows()
Dim i As Long
Dim j As Variant
j = InputBox("How many rows would you like to insert?", "Insert Rows")
If j = "" Then
j = 1
End If
For i = 1 To j
ActiveCell.Rows.EntireRow.Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Next
End Sub