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

¦p¦ó °»´ú DDE §Y®É³ø»ùªº ©³¼h °ò¦§Þ³N

¦p¦ó °»´ú DDE §Y®É³ø»ùªº ©³¼h °ò¦§Þ³N

¤Ñ¤U¬°¤½

¦^´_ 2# handsometrowa


    ¥i¥H¼g¦b¥H¤U¨Æ¥ó§õ

Private Sub Worksheet_Change(ByVal Target As Range)

if target=range("a1") then
   range("a1").end(xldown)=range("a1")
end if

End Sub

©Ò¥H·í§A¼Æ¦r¦³ÅÜ°Ê ´N·|¨ì³o¸Ì­±°õ¦æ½Æ»sªºµ{¦¡
¤Ñ¤U¬°¤½

TOP

¦^´_ 4# handsometrowa


   §ÚÁÙ¨S¦³ try, §Ú¤]¥¿¦b¹Á¸Õ ¬ð¯}³o­Ó °ÝÃD
¤Ñ¤U¬°¤½

TOP

¦^´_ 7# yuhuahsiao


    ¥i¥H ¸ò±z ¤À¨É±zªº VBAµ{¦¡Àɮ׶ܡH

±N¨Ó§Ú¼g¥X¥æ©öµ¦²¤¡A·| ¤À¨Éµ¹±z

§Úªº e-mail


sjgau4311 at gmail.com

ÁÂÁÂ
¤Ñ¤U¬°¤½

TOP

¦^´_ 9# c_c_lai


    ¦]¬°¡A§Úªº VBA ªº¹Ò¬É¬O ÄÝ©ó ªì¾Ç¡A
©Ò¥H «D±`»Ý­n¦³ ¤@­Ó½d¨Ò¥i¥H°Ñ¦Ò¡C

§Æ±æ ±z¯à°÷ ¤À¨É À°¦£
¤Ñ¤U¬°¤½

TOP

¦^´_ 11# c_c_lai


    e-mail ¦¬¨ì¡A·P®¦

¾î¬Ý¦¨À­°¼¦¨®p¡A»·ªñ°ª§C¬Ò¤£¦P

¦P¤@­Ó½L¡A¦³¤H¬Ý¦h¡A¦³¤H¬ÝªÅ
¤~·|¦³¦¨¥æ¶q
©Ò¥H¡A¤£¦PªºÆ[ÂI¬O ¥²µM¡C
¦ý¬O¡A¥Øªº ³£¬O¬°¤F ÁÈ¿ú
¤Ñ¤U¬°¤½

TOP

¦^´_ 13# yuhuahsiao


    §Ú¦¬¨ì¤F
ÁÂÁÂ

«D±` ·P®¦

©¼¦¹¥æ¬y³á
¤Ñ¤U¬°¤½

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD