Saturday, 1 September 2012

Excel VBA Macro To Insert Desired No.of Rows

Macro To Insert Desired No.of Rows
Sub Insrows()
Dim i As Integer
Dim j As Integer

ActiveCell.Select

i = InputBox("Enter The Desired No.of Rows To Insert ")

For j = 1 To i
Selection.EntireRow.Insert
Next j
End Sub

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts