- ©«¤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
|
¦^´_ 16# abc9gad2016
½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Sub tt3()
Set xD = CreateObject("Scripting.Dictionary")
Sheets("´M§ä").[B2].Resize(1, 200) = ""
T = Sheets("´M§ä").[A2]
xD(T & "") = ""
Arr = Range([¤u§@ªí1!BR64], [¤u§@ªí1!A65536].End(3))
For i = 2 To UBound(Arr)
N = xD(Arr(i, 1) & ""): If N = 0 Then GoTo 99
For j = 10 To UBound(Arr, 2)
If Arr(i, j) <> "" Then: M = M + 1: Arr(1, M) = Arr(1, j)
Next
99: Next
If M > 0 Then Sheets("´M§ä").[B2].Resize(1, M) = Arr
End Sub |
|