Hello!
I have a macro that inserts rows in excel.
But I have a problem that needs solution.
I want to make this macro inserting number of rows by pattern.
Example pattern:
A1, B1, C1 (containing data)
x100
The result should be 100 rows with info from A1, B1, C1!
Does anybody capable to do that?
Sub AddRows() iInsert = Range("E1").Value If iInsert < 1 Then Exit Sub Else For iInsert = iInsert To 1 Step -1 Selection.EntireRow.Insert Next End If End Sub
Bookmarks