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

±Æ§ÇÁä­ÈµL®Ä¡C

±Æ§ÇÁä­ÈµL®Ä¡C

ActiveSheet.Columns("A:F").Select
    Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
        :=xlStroke, DataOption1:=xlSortNormal

¦^´_ 1# av8d
§A³oµ{¦¡½X¬O¦b Sheetª«¥ó¼Ò²Õ  
¦ý ActiveSheet ¤£¬O Sheetª«¥ó¼Ò²Õªº¤u§@ªí  
Range("C2")  ¨S«ü©ú¬O¨º­Ó¤u§@ªí ´N·|¥X¿ù
³o°ÝÃD¤w¦³»¡©ú¹L
§ï¦¨   ActiveSheet.Range("C2")
¦p§A³oµ{¦¡½X¦b ThisWorkbookª«¥ó¼Ò²Õ , ¤@¯ë¼Ò²Õ¤¤´N¤£¶·§ï¤F.

TOP

¦^´_ 2# GBKEE


    §Ú­ì¥»ÁÙ¾á¤ß¨S¦³ªþ¤WÀÉ®×·|Åý¤H¤£¾å±o¿ù¦b­þ~

¨S·Q¨ìG¤jÀþ¶¡¸Ñ¨M¤F§Úªº°ÝÃD~¯u¬O¸U¤À·PÁÂ! §Ú·|¦hª`·N³o°ÝÃD~

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD