ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð±Ð ¥Î°}¦C §â ¸ê®ÆÅܦ¨¤@¦æ

[µo°Ý] ½Ð±Ð ¥Î°}¦C §â ¸ê®ÆÅܦ¨¤@¦æ

½Ð°Ý¤@¤U ¦p¦ó§â¤@°ï¦C  ³£©ñ¤J array ¤º  
²{¦b ­n©w¸q a1 a2 a3 ¨º¼Ë ¹ê¦b¬O¤ÓºC  ½Ð¤j¤j­Ì«ü±Ð

Â^¨ú.PNG (116.78 KB)

Â^¨ú.PNG

Book1.rar (5.87 KB)

Sub t()
ARR = Range([A1], [A65536].End(xlUp))
ARR = Application.Transpose(ARR)
MsgBox Join(ARR, ",")
End Sub

TOP

Sub t2()
For Each TS In Range([A1], [A65536].End(xlUp))
    If TS <> "" Then TT = TT & "," & TS
Next
MsgBox Mid(TT, 2)
End Sub

TOP

ÁÂÁ¤j¤jªº±Ð¾É

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD