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

[µo°Ý] §â¸ê®Æ¶K¦b³Ì«á¡¨¦C¡¨ªº¼gªk

[µo°Ý] §â¸ê®Æ¶K¦b³Ì«á¡¨¦C¡¨ªº¼gªk

½Ð±Ð¦U¦ì¥ý¶i

§Úª¦¤å®É¬d¨ì§â [¸ê®Æ¶K¦b³Ì«á¡¨¦C¡¨ªº¼gªk]
Range("A1:A10").Copy .Range("A65536").End(xlUp).Offset(1, 0)
¦ý¬O¦b°õ¦æ®É·|¥X²{¦p¤U¹Ïªº¿ù»~, ¬O§Ú­þÃ䲨©¿¤F
©Î¤Ö¤F¤°»òªF¦è?
Error.PNG

¥t¥~·Q½Ð±Ðªº¬O
­Y¬O·Q§âÀx¦s®æ(A16)ªº¸ê®Æ½Æ¸m¨ìSheet2ªºAÄ檺³Ì«á¤@¦C
¬O¹³³o¼Ë¤l¼g¶Ü

Range("A1:A10").Copy .Sheet2.Range("A65536").End(xlUp).Offset(1, 0)

ÁÂÁ¦U¦ì¥ý¶iªº«ü¾É

¥»©«³Ì«á¥Ñ hugh0620 ©ó 2011-12-22 12:27 ½s¿è

hi~ ¼Ó¥D~ §Aªº¼gªk¦h¤F¤@­ÓÂI
Range("A1:A10").Copy .Range("A65536").End(xlUp).Offset(1, 0)
¤U­z¬°¥¿½Tªº¼gªk
Range("A1:A10").Copy Range("A65536").End(xlUp).Offset(1, 0)

¥t¥~·Q½Ð±Ðªº¬O
­Y¬O·Q§âÀx¦s®æ(A16)ªº¸ê®Æ½Æ¸m¨ìSheet2ªºAÄ檺³Ì«á¤@¦C
¬O¹³³o¼Ë¤l¼g¶Ü
Range("A1:A10").Copy .Sheet2.Range("A65536").End(xlUp).Offset(1, 0)

¤]¥i¥H¼g¦¨
Sheet2.Range("A65536").End(xlUp).Offset(1, 0)=Range("A16")
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 2# hugh0620


    ·PÁÂHugh¤j¤j, ¦¨¥\¤F
¾Ç²ß¤F  ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD