Скачать или смотреть Don't Insert Rows Manually in Excel‼️Instead Use Amazing Tricks

In this video, you will learn how to insert rows in Excel by using VBA.

VBA code:

Sub InsertBlankRows()
Dim ws As Worksheet
Dim i As Long
Dim lastRow As Long
Dim blankRows As Integer

Set ws = ActiveSheet
lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row
blankRows = 5

' Loop from bottom to top to prevent shifting issues
For i = lastRow To 1 Step -1
ws.Rows(i + 1 & ":" & i + blankRows).Insert Shift:=xlDown
Next i
End Sub

Excel file:
https://docs.google.com/spreadsheets/...

#exceltech #exceltips #exceltutorial #excel #exceltricks #excelhacks #excelformulas #excelfunctions #excelseries #excellearn #learnexcel #excelforbeginners #microsoftexcel #msexcel #shortvideo #shorts #excelshorts #excelcourse #dataanalysis #analytics #dataanalyticscourse #analysis #exceldataanalytics #shortandclearexcel #vba