Copy and paste one cell into 48 and then repeat
Closed
katie456
-
Oct 29, 2018 at 01:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 29, 2018 at 11:52 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Oct 29, 2018 at 11:52 AM
Related:
- Copy and paste one cell into 48 and then repeat
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Copy and paste e with accent - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Why can't i copy and paste on instagram ✓ - Instagram Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Oct 29, 2018 at 11:52 AM
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