- ©«¤l
- 82
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 112
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- WIN7
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-3
- ³Ì«áµn¿ý
- 2020-9-21
|
[¤À¨É] ¶i¶¥¿z¿ï¤£¯à¸ó¤u§@ªí?¥i¥Î¥H¤U¤è¦¡
º¥ý¯uªº«Ü·PÁÂGBKEE ¤j ¦bEXCEL VBA ¼¶¼g¥X§Ú»Ýnªºµ{¦¡½X
¦]¦Ó¤Þµo¤F§Úªº¿³½ì¥h¤F¸ÑEXCEL¶i¶¥¿z¿ï
EXCELªº¶i¶¥¿z¿ï¸Ì± ¦³¤@ӫܤjªº°ÝÃD ©x¤èºô¯¸¸ÑÄÀ¦p¤U
http://support.microsoft.com/kb/909527/zh-tw
²³æ¨ÓÁ¿ ·N«ä´N¬O ¶i¶¥¿z¿ïµLªk¦bSheets("A")¤¤¶i¦æ¿z¿ï«á ¶K¨ìSheets("B")¥h
¨º¸Ó«ç»ò¿ì©O¡H ½¤F¤@¤Uºô¸ô¤å³¹¡A¦pªG§A©x¤è»¡ªº¬Ý¤£À´¨SÃö«Y
½¦¨¥Õ¸Ü¤å ·N«ä´N¬O ¦pªG§AA¤£¯à¶KB¡A¨º§Ú´N±qB¨ÓcopyAÁ`¥i¥H§a¡H
©Ò¥H¶i¶¥¿z¿ï¦pªGnÀò¨ú¤@Ó¸ê®Æ®w¤¤ªº¸ê®Æ¨Ã¥B¥u¿z¿ï¥X§ÚnªºÅܦ¨§Únªº¦Û¤v¤@±i¤u§@ªí
¨º§ÚÀ³¸Ó«ç»ò°µ©O
§Ú§â§Úªº¥Ü½d¥ÎHseih ¤jªº³nÅé°µ¦¨°ÊµeÀÉ¡A½Ð¦U¦ìÆ[¬Ý¡C
§Æ±æ¹ï¦U¦ì¦b¿z¿ï³o¤@¤è±ªº¤F¸Ñµ{«×¥i¥H¼W¥[¡A¦A¦¸·PÁ°Q½×°Ï¤¤À°¦£ªº¦U¦ìªB¤Í¡C
|
|