Trying to insert multiple rows between rows in excel with copied data.
Closed
ElderVisco
TrowaD
- Posts
- 1
- Registration date
- Sunday June 9, 2019
- Status
- Member
- Last seen
- June 9, 2019
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Excel macro to insert rows between data
- Excel vba copy and insert multiple rows - Best answers
- Excel vba insert multiple rows based on cell value - Best answers
- How to insert multiple rows in Excel with a macro? - Guide
- How to insert multiple rows in excel at regular intervals - Forum - Excel
- Macro to insert multiple rows between existin ✓ - Forum - Excel
- Insert multiple rows based on cell value - Forum - Excel
- Excel vba insert multiple rows - Forum - Excel
1 reply
TrowaD
Jun 13, 2019 at 11:44 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jun 13, 2019 at 11:44 AM
Hi Visco,
May I suggest a different code as it is easier to work for the bottom up when inserting.
Give this a shot:
Best regards,
Trowa
May I suggest a different code as it is easier to work for the bottom up when inserting.
Give this a shot:
Sub RunMe() Dim lRow, x As Integer lRow = Sheets("Sheet1").Range("A1").End(xlDown).Row + 1 For x = lRow To 3 Step -1 Sheets("Sheet2").Range("A1:A13").Copy Range("A" & x).Insert Shift:=xlDown Next x End Sub
Best regards,
Trowa