![]() |
|
#1
|
|||
|
|||
![]()
This should get you started
Code:
Sub Macro2_CopyPasteTRANSPOSE() Dim i As Long Dim x As Long: x = 6 Dim LastRow As Long LastRow = Range("A" & Rows.Count).End(xlUp).Row Application.ScreenUpdating = False For i = 1 To LastRow Step 8 Range("A" & i).Resize(6).Copy Range("B" & x).PasteSpecial xlPasteAll, , , Transpose:=True x = x + 3 Next i Application.CutCopyMode = False Application.ScreenUpdating = True End Sub |
![]() |
Tags |
copy paste special loop |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
spiderman1369 | Word VBA | 2 | 10-15-2014 08:30 AM |
![]() |
tinfanide | Word | 6 | 03-06-2013 12:21 AM |
![]() |
cyndor | Word | 2 | 04-06-2012 03:57 AM |
![]() |
iconofsin | Excel | 1 | 09-15-2010 12:10 AM |
![]() |
Dace | Excel | 2 | 02-16-2009 12:18 PM |