|
' If (i Mod 24) = 1 Then
' k = k + 1
' Cells(i, 1).Resize(24).Merge
'Cells(i, 1) = Sheets("填表").Cells(k + 1, 1)
'Brr(i, 1) = Arr(j, 1) '写入 名称
' End If
sheet1中每一行数据对应sheet2中24行结果,想在sheet2中将24行合并生成sheet1一样的标题
- Sub 合并()
- Dim i As Long, k As Long
- Dim arr
- Application.ScreenUpdating = False
- With Worksheets("填表")
- arr = .Range("a1").CurrentRegion
- End With
- With Worksheets("命令")
- For i = 2 To UBound(arr)
- k = (i - 2) * 24 + 1
- .Range("a" & k).Resize(24).Merge
- .Range("a" & k) = arr(i, 1)
- Next
- End With
- Application.ScreenUpdating = True
- MsgBox "合并完成", vbInformation
- End Sub
复制代码
|
|