- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2023-9-21
|
¦^´_ 1# johnny1680
²¤Æ#2¡AÁÂÁÂ
Sub test2()
Dim Arr, xD
Set xD = CreateObject("Scripting.Dictionary")
Arr = Range("a1:a101")
For i = 6 To UBound(Arr) Step 5
If xD.Exists(Arr(1, 1)) Then
Arr(i, 1) = xD(Arr(1, 1)) + 10
xD(Arr(1, 1)) = Arr(i, 1)
Else
Arr(i, 1) = Arr(1, 1) + 10
xD(Arr(1, 1)) = Arr(i, 1)
End If
Next
Range("a1").Resize(UBound(Arr), 1) = Arr
End Sub |
|