- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
q1¼Ò²Õ¡G- Private Sub CommandButton1_Click()
- Dim n%
- [a:a] = [a:a].Value
- [w:ai] = ""
- Application.ScreenUpdating = 0
- n = [a65536].End(3).Row
- [w6].Consolidate "R6C1: R" & n & "c21", xlSum, 1, 1
- [x:ae].Delete
- [w6] = [a6]
- End Sub
½Æ»s¥N½X q2¼Ò²Õ¡G- Sub yy()
- Dim rng, arr, d As Object, i%, j%, m%
- [ai:bh] = ""
- rng = Range([a6], [ag65536].End(3))
- Set d = CreateObject("Scripting.Dictionary")
- ReDim arr(1 To UBound(rng), 1 To 13)
- arr(1, 1) = rng(1, 1)
- For j = 2 To 13
- arr(1, j) = Left(rng(1, 8 + c + j), 6): c = c + 1
- Next
- m = 1
- For i = 2 To UBound(rng)
- If d(rng(i, 1)) = "" Then
- m = m + 1
- d(rng(i, 1)) = m
- arr(m, 1) = rng(i, 1): c = 0
- For j = 2 To 13
- arr(m, j) = rng(i, 8 + c + j) - rng(i, 8 + c + j + 1): c = c + 1
- Next
- Else
- c = 0
- For j = 2 To 13
- arr(d(rng(i, 1)), j) = arr(d(rng(i, 1)), j) + rng(i, 8 + c + j) - rng(i, 8 + c + j + 1): c = c + 1
- Next
- End If
- Next
- [ai6].Resize(m, 13) = arr
- End Sub
½Æ»s¥N½X |
|