¡@¼ÊºÙ: ªü¦N ¡@ÀY»Î: ¤£®¢¤U°Ý,¤£Â_¾Ç²ß,¤~·|¶i¨B
ª©¥D  
- ©«¤l
- 647
- ¥DÃD
- 190
- ºëµØ
- 24
- ¿n¤À
- 1037
- ÂI¦W
- 0
- §@·~¨t²Î
- windows7
- ³nÅ骩¥»
- Office 2010 ; OOO3.0 ; Google
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦Ë«n
- µù¥U®É¶¡
- 2010-5-2
- ³Ì«áµn¿ý
- 2022-6-24
  
|
¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-2-7 17:37 ½s¿è
¤u§@ªíÁôÂìOEXCEL¤¤«Ü±`¨Ï¥Îªº§Þ¥©
¥»¦¸»¡©ú
1.¤u§@ªíÁôÂÃ
2.¤u§@ªí«D±`ÁôÂÃ
3.¬¡¶Ã¯«OÅ@
¦b¥æ¤e¹B¥Î®ÉªºÃö«Y
------------------------------------------------------------------------------
¦b¤@¯ë¥¿±`EXCEL¾Þ§@¤¤§Ú̵Lªk¨Ï¥Î"½Æ»s¤u§@ªí"±NÁôÂ꺤u§@ªí½Æ»s¨ì·s¬¡¶Ã¯
¦p¤U¹Ï¥u¦³³o¤u¨ã§Ú̬ݤ£¨ìÁôÂäu§@ªí¡A·íµM¤]´NÂI¤£¨ìÁôÂäu§@ªí¤£¯à¨Ï¥Î"½Æ»s¤u§@ªí"¨ì·s¬¡¶Ã¯
¦Ó¹ê»Ú¦³3Ó¤u§@ªí
vba¬O§Ú们±`¨Ï¥Îªº»y¨¥»P¤u¨ã
·í¤u§@ªíÁôÂîɧÚÌ¥i§_±N¤u§@ªí¥Î¨î¦¡vba»y¨¥sheets.copy½Æ»s¾ã±i¤u§@ªí¨ì·s¬¡¶Ã¯
a.¤u§@ªíÁôÂáA¥i¥H¥Îsheets.copy½Æ»sÁôÂäu§@ªí
b.¤u§@ªí«D±`ÁôÂáA¤£¥i¥H¥Îsheets.copy½Æ»s«D±`ÁôÂäu§@ªí
µ²½×1:¦pªG¥u¬O"¤u§@ªíÁôÂÃ"§ÚÌ¥i¥H«Ü»´ÃPªº¥Îsheets.copy½Æ»s¾ã±i¤u§@ªí¨ì·s¬¡¶Ã¯
¦Ó"¤u§@ªí«D±`ÁôÂÃ"«h»Ýn¨ä¥LºØÃþ³B²z¤~¯à½Æ»s¾ã±i¤u§@ªí¨ì·s¬¡¶Ã¯
------------------------------------------------------------------------------
¦³¤H·|»¡´N§â¤u§@ªí¸Ñ°£ÁôÂæAcopy¤£´N¦n¤F!
§Ú̦A¥[¤@¼h¨Ï¥Î¬¡¶Ã¯«OÅ@µ²ºc¡A¨¾¤î¤u§@ªí³Q¸Ñ°£ÁôÂÃ
µ²½×2:´Nºâ¬O¨Ï¥Î"¬¡¶Ã¯«OÅ@µ²ºc"§Ṳ́´¥i¥H«Ü»´ÃPªº¥Îsheets.copy½Æ»s¾ã±i¤u§@ªí¨ì·s¬¡¶Ã¯
¦Ó"¤u§@ªí«D±`ÁôÂÃ"«h»Ýn¨ä¥LºØÃþ³B²z¤~¯à½Æ»s¾ã±i¤u§@ªí¨ì·s¬¡¶Ã¯
------------------------------------------------------------------------------
¼o¸Ü¤£¦h»¡
Á`µ²½×»P¤p§Þ¥©¹B¥Î:
1.§ÚÌ¥i¥H¨Ï¥Î¦¹§Þ¥©"¯}¸Ñ¬¡¶Ã¯«OÅ@"(·íµM³o¤£¬O¯uªº¯}¸Ñ)
2.Y¬O2000ª©§Ṳ́]¥i¥H¨Ï¥Î¥t¥~³o«h¤p§Þ¥©¯}¸Ñ¬¡¶Ã¯«OÅ@
[ì³Ð] ¬¡¶Ã¯«OÅ@Æ[©À»P¤p§Þ¥©
¨Ï¥Îì²z:
·í¬¡¶Ã¯µ²ºc³Q«OÅ@¥B¥u¦³Â²©öÁôÂäu§@ªí®É¡A§ÚÌ¥i¥H¨Ï¥Î¦¹¤èªkSheets.Copy¤u§@ªí
±N¤u§@ªí²æÂ÷쬡¶Ã¯¡A¦¹®É·s¬¡¶Ã¯´N¨S¦³¬¡¶Ã¯«OÅ@µ²ºcªº«OÅ@=¤£¥Î¯}¸Ñ¬¡¶Ã¯µ²ºc¡A¦b·s¬¡¶Ã¯´N¥i¥H¨ú®ø¤§«eÁôÂêºÁôÂäu§@ªí¡AÆ[¬Ý»P¨Ï¥Î¤º®e- Sub Macro1()
- Sheets.Copy
- End Sub
½Æ»s¥N½X p.s.¦pªG¬¡¶Ã¯¤º¦³vba¥¨¶°»P«D±`ÁôÂäu§@ªí¤£«Øij¨Ï¥Î¦¹ªk(¼Ò²ÕSheet¥i¥Î)
and¦¹ªk²³æ©ö¥Î¡A¥Î¦b¤@¯ë¬¡¶Ã¯¸Ñ°£®É¬O«D±`¦n¥Î |
|