- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¦^´_ 15# ã´£³¡ªL
³o¬O쥻·Qnªº·j´Mµ²ªG, ¦ý¦Û¤vµo¿ùªº°ÝÃD...
µL½×¦p¦ó, ÁÂÁÂã¤j..
Rept code
40000001
Rept 40000001
40000002
Rept 40000002
40000003
40000004
Rept 40000004
40000005
Rept 40000005
40000006
Rept 40000006
Rept 40000006
Rept 40000006
Sub test_04()
Dim Arr, xD, i&, T$, U&, TM
TM = Timer
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range([C2], Cells(Rows.Count, 3).End(3))
For i = UBound(Arr) To 1 Step -1
T = Arr(i, 1): U = xD(T): Arr(i, 1) = ""
If U > 0 Then Arr(U, 1) = "Rept": xD(T) = -1: U = -0
If U = 0 Then xD(T) = i
Next i
[B2].Resize(UBound(Arr)) = Arr
MsgBox Timer - TM
End Sub |
|