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

[­ì³Ð] Ãö©ó¤u§@ªíÁôÂÃÆ[©À»¡©ú

[­ì³Ð] Ãö©ó¤u§@ªíÁôÂÃÆ[©À»¡©ú

¥»©«³Ì«á¥Ñ 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¬¡­¶Ã¯

2011-02-07 15-19-54.jpg

¦Ó¹ê»Ú¦³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
  1. Sub Macro1()
  2. Sheets.Copy
  3. End Sub
½Æ»s¥N½X
p.s.¦pªG¬¡­¶Ã¯¤º¦³vba¥¨¶°»P«D±`ÁôÂäu§@ªí¤£«Øij¨Ï¥Î¦¹ªk(¼Ò²ÕSheet¥i¥Î)
and¦¹ªk²³æ©ö¥Î¡A¥Î¦b¤@¯ë¬¡­¶Ã¯¸Ñ°£®É¬O«D±`¦n¥Î

b.¤u§@ªí«D±`ÁôÂáA¤£¥i¥Hsheets.copy½Æ»s
HUNGCHILIN µoªí©ó 2011-2-7 14:46

¥i¥H¥Î Cells.Copy ¨ú±o «D±`ÁôÂäu§@ªí¤¤Cellsªº¤º®e¤Î®æ¦¡
1

µû¤À¤H¼Æ

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD