Live Interactive Virtual LearningLive interactive virtual classes are available for our public scheduled courses as well as group or in-house training requests.
Experience training in the comfort of your home or office!
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.