Sub Insert_Rows() Dim lLastRow As Long, li As Long Application.ScreenUpdating = 0 lLastRow = Cells(Rows.Count, 1).End(xlUp).Row For li = lLastRow To 1 Step -1 Rows(li).Resize(2).Insert Next li Application.ScreenUpdating = 1End Sub
Sub aaa()Sheets("Лист5").Activater = 3Do Until IsEmpty(Sheets("Лист5").Cells(r, 2)) If Sheets("Лист5").Cells(r, 4) < 0 Then RowNumb = Sheets("Лист5").Cells(r, 4).Value Sheets("Лист5").Rows(r).Select For i = 1 To -RowNumb Selection.Insert Shift:=xlDown Next Range(Cells(r - 2, 2), Cells(r - 1, 2)).Select Selection.AutoFill Destination:=Range(Cells(r - 2, 2), Cells(r, 2)), Type:=xlFillDefault Selection.AutoFill Destination:=Range(Cells(r - 2, 2), Cells(50000, 2)) End If r = r + 1LoopEnd Sub
Sub Insert_Rows() Dim lLastRow As Long, li As Long Application.ScreenUpdating = 0 lLastRow = Cells(Rows.Count, 1).End(xlUp).Row For li = lLastRow To 1 Step -1 Rows(li).Resize(2).Insert Next li Application.ScreenUpdating = 1 End Sub
For li = lLastRow To 1 Step -3
Sub Insert_Rows() Dim lLastRow As Long, li As Long Application.ScreenUpdating = 0 lLastRow = Cells(Rows.Count, 1).End(xlUp).Row For li = lLastRow To 1 Step -2 Rows(li).Resize(2).Insert Next li Application.ScreenUpdating = 1 End Sub
Sub Insert_Rows() Dim lLastRow As Long, li As Long Application.ScreenUpdating = 0 lLastRow = Cells(Rows.Count, 1).End(xlUp).Row For li = lLastRow To 1 Step -3 Rows(li).Resize(3).Insert Next li Application.ScreenUpdating = 1 End Sub
Sub Insert_Rows() Dim lLastRow As Long, li As Long Application.ScreenUpdating = 0 lLastRow = Cells(Rows.Count, 1).End(xlUp).Row For li = lLastRow To 1 Step -3 Rows(li + 1).Resize(3).Insert Next li Application.ScreenUpdating = 1End Sub
Sub Insert_Rows() Dim arr, x Application.ScreenUpdating = 0 For Each x In Array("Лист1", "Лист2", "Лист3") ActiveWorkbook.Sheets(x).Rows(3).Insert Next Application.ScreenUpdating = 1End Sub
Sub Insert_Rows_2() Sheets(Array("Лист1", "Лист2", "Лист3")).Select Rows(3).Insert Sheets("Лист1").SelectEnd Sub