To insert rows required by a user is easy. Here the input box is used so that a user can define the number of rows required.
Rng = InputBox("Enter number of rows required.")
Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(Rng - 1, 0)).Select
Here the macro uses the range technique where a range is first selected and then subsequently rows are inserted.