|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d = CreateObject("scripting.dictionary")
- With Worksheets("编排依据")
- For j = 1 To 9 Step 4
- r = .Cells(.Rows.Count, j).End(xlUp).Row
- arr = .Cells(1, j).Resize(r, 3)
- For i = 2 To UBound(arr)
- If Not d.exists(arr(i, 1)) Then
- m = 1
- ReDim brr(1 To 3, 1 To m)
- Else
- brr = d(arr(i, 1))
- m = UBound(brr, 2) + 1
- ReDim Preserve brr(1 To 3, 1 To m)
- End If
- brr(1, m) = arr(1, 3)
- brr(2, m) = arr(i, 3)
- brr(3, m) = arr(i, 2)
- d(arr(i, 1)) = brr
- Next
- Next
- End With
- With Worksheets("标签成品全部样本")
- .Range("a6:i" & .Rows.Count).Clear
- n = 1
- q = 1
- .Range("a3:c5,g3:i5").ClearContents
- For Each aa In d.keys
- brr = d(aa)
- ReDim crr(1 To UBound(brr, 2), 1 To UBound(brr))
- For i = 1 To UBound(brr)
- For j = 1 To UBound(brr, 2)
- crr(j, i) = brr(i, j)
- Next
- Next
- .Cells(1, n) = "第" & aa & "考场"
- With .Cells(1, n)
- .Value = "第" & aa & "考场"
- With .Characters(Start:=2, Length:=Len(aa)).Font
- .Name = "Times New Roman"
- .Size = 60
- End With
- End With
- .Cells(3, n).Resize(UBound(crr), UBound(crr, 2)) = crr
- n = n + 6
- If n > 7 Then
- q = q + 7
- .Range("a1:i5").Copy .Cells(q, 1)
- .Range("a3:c5,g3:i5").ClearContents
- n = 1
- End If
- Next
- If d.Count Mod 2 <> 0 Then
- q = q + 7
- .Range("a1:i5").Copy Cells(q, 1)
- End If
- .Range("a1:i7").Delete shift:=xlUp
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|