Quality, Affordable & Flexible
Take advantage of our Microsoft Office Series public courses’ Buy 2 Get 1 FREE package!!
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.