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

[µo°Ý] ¤U­Ó¤ë·sÀÉ

¥»©«³Ì«á¥Ñ »a³· ©ó 2020-1-5 23:22 ½s¿è

¦^´_ 4# PJChen


    ¤p§Ì§Ú¸ÕµÛ§ï¤F¤@¤U¡A½ÐªA¥Î¡C

    ­ì¥»§A¼gªº§Ú¦³«O¯d¡AÅܦ¨µù¸Ñ±¡ªp¡A¥i¥H¸ò§Ú¼gªº°Ï¶ô¤ñ¹ï¤@¤U¡C

    ¦]¬°­n§ì°Ó«~ªºrow¼Æ¶q¡A©Ò¥H cells(rows.count,"C").end(xlup).row ¥²¶·¬O¥H...

    workbooks("°Ó«~.xlsx").WORKSHEETS("·s¤ë").cells(rows.count,"C").end(xlup).row¤U¥h¼g¡A¤~·|¥h§ì¨ì¸ÓSheetªºrow¼Æ¶q¡C

    «e´£¬Oworkbook °Ó«~¬O­n¶}±Òªºª¬ºA¡C Macro_T.zip (14.6 KB)

TOP

¦^´_ 6# PJChen


    ·|´`Àô¶Ü...§Ú¦Û¤v¦brunªº®É­Ô¬O¨S°ÝÃD°ÕXD

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD