Public d
Public r
Public arr
Public m
Sub lqxs_zd()
Application.ScreenUpdating = False
Sheets("code").UsedRange.ClearContents
Set d = CreateObject("scripting.dictionary")
arr = Sheets(1).[a1].CurrentRegion
m = 7
r = 1
For j = 1 To UBound(arr, 2)
d(j) = j
dg j
a = d.Count
d.Remove j
Next j
Application.ScreenUpdating = True
End Sub
Sub dg(y)
For j = y + 1 To UBound(arr, 2)
d(j) = j
If d.Count = m Then
For i = 0 To 6
Sheets(1).Cells(1, d.keys()(i)).Resize(7).Copy Sheets(2).Cells(r, i + 1)
Next i
r = r + 7
Else
dg j
End If
If d.exists(j) Then d.Remove j
Next j
End Sub