Copy and paste one cell into 48 and then repeat
Closed
katie456
-
Oct 29, 2018 at 01:05 AM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Copy and paste one cell into 48 and then repeat
- A macro to copy/paste a cell and other cells in the same row ✓ - Forum - Excel
- Lookup/Identify next number,Paste into cell ✓ - Forum - Office Software
- How to copy and paste alternate cells in excel - Forum - Excel
- Macro copy and paste in next blank cell - Guide
- Macro copy and paste in next blank cell ✓ - Forum - Excel
1 reply
TrowaD
Oct 29, 2018 at 11:52 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 29, 2018 at 11:52 AM
Hi Katie,
Give the following code a try:
Best regards,
Trowa
Give the following code a try:
Sub RunMe() Dim x As Integer x = 2 For Each cell In Range("J2:J389") cell.Copy Range(Cells(x, "G"), Cells(x + 47, "G")) x = x + 48 Next cell End Sub
Best regards,
Trowa