Excel VBA Macro To Insert Desired No.of Rows | SQL Server | T-SQL | SSIS | Power BI | R Programming

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: Post Comments (Atom)