Hi all,

I have a formula that pastes rows into the excel sheet based on how many rows the user wants. However, it copies over pre-existing data.

Can anyone modify this VBA so it shifts all of the rows down?
Additionally, is it possible to copy the previous row and paste it instead of inserting new rows?

Sub x()
Dim nRows As Long
nRows = Application.InputBox("No of rows to insert?", "Insert Rows", , , , , , 1)
ActiveCell.Offset(1).Resize(nRows).EntireRow.Insert
End Sub

Thanks for the help!