ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD