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

[µo°Ý] VBA¨½ªº¤¤¤åcopy¨ìsheet¶Ã½X,¦³µLsetting¥i¥H¸Ñ¨M

[µo°Ý] VBA¨½ªº¤¤¤åcopy¨ìsheet¶Ã½X,¦³µLsetting¥i¥H¸Ñ¨M

VBA¨½ªº¤¤¤åcopy¨ìsheet¶Ã½X,¦³µLsetting¥i¥H¸Ñ¨M,½Ð±Ð¦U¦ì
lmh

¦^´_ 1# mhl9mhl9

§A¥i¥H¸Õ¸Õ¶×¥Xªº¥\¯à...
¦bvb ½s¿è¾¹¤¤¡AÀÉ®×->¶×¥XÀɮסA¥i¥H¶×¥X .bas ÀÉ
¥Î¤@¯ëªº¤å¦r½s¿è¾¹ (ex: °O¨Æ¥») ´N¥i¥H¥´¶}
¥´¶}¦A copy/past ´N¥i¥H¤F....

TOP

¦^´_ 2# hipper68


    ÁÂÁÂ,§A¬O¤£¬O°O±o¥H«eª©¥»excel,¬O¥i¥Hcopy¨ìsheet¦Ó¤£·|¶Ã½Xªº
lmh

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD