- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2025-2-15
|
¼Æ¾Ú·½À³ÁקK¥Îµ{¦¡Âл\¤@¦¸, ¥u¦C¥Xµ²ªG¦ì¸m§Y¥i~~
Y¸ê®Æ¦h¥BÄæ¦ì¦h, ¾ãÓ«·s¶K¤W´N·|©ìºC³t«×.
Sub TEST_A1()
Dim Arr, T$, i&, j%
Arr = Range("J1:AC" & Cells(Rows.Count, 1).End(3).Row)
For i = 2 To UBound(Arr)
For j = 1 To UBound(Arr, 2)
T = Trim(T & " " & Trim(Arr(i, j)))
Next j
Arr(i - 1, 1) = Replace(T, " ", ","): T = ""
Next i
With [ad2].Resize(UBound(Arr) - 1)
.NumberFormatLocal = "@"
.Value = Arr
End With
End Sub |
|