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

½Æ»s¼Æ­È

½Æ»s¼Æ­È

¦U¦ì¤j¤j§A¦n:

§Ú°µ¤F¤@­Ó²³æªº¶i¾P®w¦svbaÀÉ®×, §Ú³]©w¤F¤@­Ó¬O¨ú¦^¤§«e¤ë¥÷³æ»ù, ¤@­Ó¬O­pºâÁ`»ù­È«öÁä, ¦Ó¦b2019.01~2019.03 ³£¨S¦³°ÝÃD, ¦ý¦b2019.04 ®w¦s´N¤£¯à¨ú¦^¤§«e¤ë¥÷ªº¦U¦ì¤j¤jÀ°¦£¬Ý¬Ý¨º¨½¥X°ÝÃD,

ÁÂÁÂ

20190318_¦sªí (VBA).rar (169.5 KB)

¦^´_ 1# mdr0465

½Ð±NSheets(11)§ï¬°Sheets(10)
Sheets(¼Æ­È)¬O¥H¤u§@­¶Page±Æ§Ç­pºâ,¤£¬O¬Ýµ{¦¡¤¶­±¸Ì­±¦h¤Ö¦Ó©w
2019.04®w¦sªº²Ä10­ÓPage,©Ò¥H¬OSheets(10),¦Ó«Dµ{¦¡­¶­±Åã¥Üªºsheet11

TOP

¦^´_ 2# jcchiang


jcchiang ÁÂÁ§Aªº¦^ÂÐ
¦ý§Ú¤S¦³¤@­Ó°ÝÃD, ¦pªG¬O«ö·Ósheet ªº±Æ§Ç¨Ó­pºâsheet ªº­¶¼Æ, ¦pªG§Ú±N­¶¼Æ²¾°Ê,³o¼Ë·|¤£·|¼vÅT§Ú­pºâ©O?? ÁÙ¬O¦³¤@­Ó¤èªk¥i¥H¤è«KÚ»¨ì¥¿½Tªº­¶¼Æ??

ÁÂÁÂ

TOP

¦^´_ 3# mdr0465

§ï¥Îsheets("¤u§@­¶¦WºÙ")
EX:sheets("2019.04®w¦s")

«e­±ªº¦^ÂвÄ10­ÓPageÀ³¸Ó¬O2019.03®w¦s,¦]¬°µ{¦¡¬O§ì«e¤@­Ó¤ë¸ê®Æªº³æ»ù

TOP

¦^´_ 4# jcchiang


©ú¥Õ,ÁÂÁ§A

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD