Related:
- Macro to insert rows between data
- Excel macro to insert rows between data - Best answers
- How to insert multiple rows in excel between data - Best answers
- Excel Macro to insert row based on data ✓ - Forum - Excel
- Macro to insert row in excel based on criteria ✓ - Forum - Excel
- Excel auto insert row when data changes ✓ - Forum - Excel
- Insert rows with data when criteria is met ✓ - Forum - Excel
- Excel formula to insert rows between data ✓ - Forum - Excel
1 reply
TrowaD
- Posts
- 2690
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 12, 2021
Hi vba dummy,
Assuming that there are no empty rows between the data you have and a row of data always has something in column A, try this code:
How to implement and run a code:
- From Excel hit Alt + F11 to open the “Microsoft Visual Basic” window.
- Go to the top menu in the newly opened window > Insert > Module.
- Paste the code in the big white field.
- You can now close this window.
- Back at Excel, hit Alt + F8 to display the available macro’s.
- Double-click the macro you wish to run.
NOTE: macro’s cannot be reversed using the blue arrows. Always make sure you save your file before running a code, so you can re-open your file if something unforeseen happens or you want to go back to the situation before the code was run.
Best regards,
Trowa
Assuming that there are no empty rows between the data you have and a row of data always has something in column A, try this code:
Sub RunMe()
Dim x As Integer
x = 2
Do
Rows(x).Resize(45).Insert
x = x + 46
Loop Until IsEmpty(Cells(x, "A"))
End Sub
How to implement and run a code:
- From Excel hit Alt + F11 to open the “Microsoft Visual Basic” window.
- Go to the top menu in the newly opened window > Insert > Module.
- Paste the code in the big white field.
- You can now close this window.
- Back at Excel, hit Alt + F8 to display the available macro’s.
- Double-click the macro you wish to run.
NOTE: macro’s cannot be reversed using the blue arrows. Always make sure you save your file before running a code, so you can re-open your file if something unforeseen happens or you want to go back to the situation before the code was run.
Best regards,
Trowa
Subscribe To Our Newsletter!
