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

[µo°Ý] ½Ð±Ð VBA

[µo°Ý] ½Ð±Ð VBA

»¡©ú¦b¤º..ÁÂÁ«ü¾É
¬¡­¶Ã¯1.rar (15 KB)

¥»©«³Ì«á¥Ñ samwang ©ó 2021-6-22 19:53 ½s¿è

¦^´_ 1# duck_simon


­ì¥»±z¦Û¤vªºµ{¦¡½X´N¥i¥H°õ¦æ¨º­Ó»Ý¨D¤F§a?

TOP

¦^´_ 2# samwang


¦^¤j¤j  ­ì¥ý­nkeyin ¤@¦¸..·Q§ï¬°
¥u­n ±q¤u§@ªí±±¨î¶µ  °õ¦æ½Æ»s¼Æ¾Ú..´N¥i¥H°õ¦æ¸Ó°Ê§@

TOP

¦^´_ 3# duck_simon


¥u­n ±q¤u§@ªí±±¨î¶µ  °õ¦æ½Æ»s¼Æ¾Ú..´N¥i¥H°õ¦æ¸Ó°Ê§@
--> ±z­ì¥»¨º¬qµ{¦¡½X´N¦³¨º­Ó¥\¯à¡A¦]¬°¥u­nA1¦³°Ê§@¡A´N±NA1­È½Æ»s¨ìBÄ榳¼Æ­Èªº³Ì«á¤@­Ó
       ©ÎªÌ¥i¥Hª½±µ±N§A­ì¥»ªº"A1 ¬O¥Ñ¥L¤u§@ªí copy¹L¨Ó"¡A¨º¬qµ{¦¡½Xª½±µcopy ¨ìBÄ榳¼Æ­Èªº³Ì«á¤@­Ó¦p¤U½d¨Ò
        [A1].Copy [B65536].End(xlUp).Offset(1, 0)
        ¸ê®Æ¨Ó·½.Copy [B65536].End(xlUp).Offset(1, 0)

¬¡­¶Ã¯1.zip (20.91 KB)

TOP

«á­±¦b¥[¤@¦æ¡AÅý¿é¤J§ó¶¶ºZ
[A1].Select
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  duck_simon


¥u­n ±q¤u§@ªí±±¨î¶µ  °õ¦æ½Æ»s¼Æ¾Ú..´N¥i¥H°õ¦æ¸Ó°Ê§@
--> ±z­ì¥»¨º¬qµ{¦¡½X´N¦³ ...
samwang µoªí©ó 2021-6-23 07:35



    ·PÁ ¥ý¶i«ü¾É ÁÂÁÂ

TOP

«á­±¦b¥[¤@¦æ¡AÅý¿é¤J§ó¶¶ºZ
[A1].Select
ML089 µoªí©ó 2021-6-23 09:46



    ·PÁ¤j¤j «ü¾É ÁÂÁÂ

TOP

¦^´_ 7# duck_simon


   

±±¨î¶µ

®t­È.jpg
2021-6-23 10:51

²{¦b  ±±¨î¶µ ²£¥Í²{¶H ­ì¦]¬°¦ó?

TOP

¦^´_ 8# duck_simon


¤è«K´£¨Ñªþ¥ó¡A³o¼Ë¤ñ¸û®e©öª¾¹D°ÝÃD©M»Ý¨D¡A·PÁ¡C

TOP

¦^´_ 9# samwang


    ÁÂÁÂ¥ý¶i«ü¾ÉÅo!

ºû2.rar (73.76 KB)

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD