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

Ãö©ócopy¦Ü¥t¤@¤u§@­¶

Ãö©ócopy¦Ü¥t¤@¤u§@­¶

½Ð±Ð¡G
¥ý¦b¨ä¥¦¤u§@­¶¤W°õ¦æ©Ò»Ý­nªº¸ê®Æ¿z¿ï«á¡A½Æ¨î¡A¦A¿ï¨ä¥¦¤u§@­¶¶K¤W¡A­ì«h¤W³£¥i¥¿±`°õ¦æ¡A
¦ý¬O¡A­Y¦b°õ¦æ¥¨¶°«e¡A·Æ¹«­Y¦b­q³æ¤u§@­¶¤WÂI¦b¬Y¤@Àx¦s®æ´NµLªk°õ¦æ¡A­Y¬O¥H·Æ¹«¥þ¿ï¾ã­Ó¤u§@­¶ªº¸Ü¡A´N¥i¥H¥¿±`°õ¦æ¡A½Ð°ÝÀ³¸Ó«ç»ò±Æ°£¡I
ActiveSheet.AutoFilter.Range.SpecialCells(xlCellTypeVisible).EntireRow.Copy
Sheets("­q³æ").Select
Selection.PasteSpecial
·s¤H¤@ªT

¦]¬°entire row ¤£¯à¦bcolumn A¥H«á¦ì¸m¶K¤W
¥[ªðselect A1 cell§Y¥i

ActiveSheet.AutoFilter.Range.SpecialCells(xlCellTypeVisible).EntireRow.Copy
Sheets("­q³æ").Select
Activesheet.range("A1").select
Selection.PasteSpecial

TOP

·PÁ¸ѱϡI
·s¤H¤@ªT

TOP

¦^´_ 1# eric093
  1. ).EntireRow.Copy  '¾ã¦C,©Î ¾ãÄæ½Æ»s
½Æ»s¥N½X
©Ò¶K¤WªºÀx¦s®æ(ÂI)¥²¶·¬O¦C©ÎÄæ,ªº²Ä¤@­Ó Cell (¤~²Å¦X¾ã¦C,©Î¾ãÄ檺½d³ò)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 4# GBKEE

·PÁª©¤j¡I¤F¸Ñ¤F¡I
·s¤H¤@ªT

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD