VBA ¦b°j°é¤¤¿ï¨ú¥t¤@¤u§@ªíªºÀx¦s®æ½d³ò
- ©«¤l
- 824
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 904
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2023-12-24
|
¥»©«³Ì«á¥Ñ luhpro ©ó 2013-11-12 23:26 ½s¿è
¦^´_ 1# snakei14702
1. ¤£¦æ.
Select ¥u¯à¥Î¦b WorkSheet (¹B§@¤¤ªº¤u§@ªí,©Î¬O¥Ø«e¯à¬Ý¨ìªº¤u§@ªí)¤W,
¬G¦Ó§An¥ý¥H Sheets("¤u§@ªí2").Acticate ±Nµe±¤Á´«¦Ü ¤u§@ªí2,
¤~¯à¹ï¨ä¤ºªºÀx¦s®æ°µ Select ªº°Ê§@,
¤£¹LY¬O·Q Copy ªº¸Ü¬O¥i¥H¤£¥Î±NµJÂI¤Á¹L¥h¸ÓSheet,
¦Ó¬Oª½±µ´N¥i¥H Copy ªº.
2.
.Rows(1).Select
.Rows("1:5").select
.Rows(lRow & ":" & lRow + 3).Select
¦^´_ joey0415
¤£¦n·N«ä...½Ð°Ý¤@¤Uªþ¥ó¨Æ¤°»òªF¦è©O?
ÁÂÁÂ...
snakei14702 µoªí©ó 2013-11-12 23:16
ªþ¥ó:
´N¬On "¤W¶Ç" ½d¨ÒÀɨì³oÓºô¯¸¤W,
¨Ã±N¤W¶ÇªºÀÉ®×¥[¨ì¥¿¦bµoªíªº¤å³¹¤º,
¥H«K¥L¤H¥i¥H¤U¸ü©Î°Ñ¾\.(n°O±o¥h°£¥i¯à¥]§tÓ¤H¸ê®Æªº¸ê®Æ¤º®e) |
|
|
|
|
|
|