|
本帖最后由 sunjing-zxl 于 2012-1-14 13:17 编辑
- Sub aa()
- Dim d As New Dictionary
- Dim arr, arr1, arr2
- Dim i As Long, m As Long, n As Long
- With Sheets("登记表")
- arr = .Range("F4:F" & .[F65536].End(xlUp).Row)
- End With
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = d(arr(i, 1)) + 1
- Next i
- m = Int((d.Count - 1) / 27) + 1
- n = m * 4
- ReDim arr1(1 To 1, 1 To n)
- ReDim arr2(1 To 27, 1 To n)
- For i = 1 To m
- arr1(i, (i - 1) * 4 + 1) = "No."
- arr1(i, (i - 1) * 4 + 2) = "曲谱书籍"
- arr1(i, (i - 1) * 4 + 3) = "数量"
- Next i
- For i = 1 To d.Count
- arr2(((i - 1) Mod 27) + 1, Int((i - 1) / 27) + 1) = i
- arr2(((i - 1) Mod 27) + 1, Int((i - 1) / 27) + 2) = d.keys(i - 1)
- arr2(((i - 1) Mod 27) + 1, Int((i - 1) / 27) + 3) = d.items(i - 1)
- Next i
- Range("E3:P" & [E65536].End(xlUp).Row + 2).ClearContents
- Range("E3").Resize(1, UBound(arr1, 2)) = arr1
- Range("E4").Resize(27, UBound(arr2, 2)) = arr2
- End Sub
复制代码 附件:
吉它曲谱表_试验-sunjing.rar
(17.53 KB, 下载次数: 3)
|
|