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

[µo°Ý] ¦p¦ó±N¥¨¶°¦Ó¦¨ªº"±Æ§Ç"§ï¦¨¥Ø«e¿ï¨ú¤¤ªº±Æ§Ç

[µo°Ý] ¦p¦ó±N¥¨¶°¦Ó¦¨ªº"±Æ§Ç"§ï¦¨¥Ø«e¿ï¨ú¤¤ªº±Æ§Ç

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

¥H¤W¬O°w¹ïCÄæ±Æ§Ç¦a¥¨¶°

¬O§_¥i¥H§ï¼g¦¨°w¹ï¥Ø«e©Ò¿ï¨ú½d³òªº±Æ§Ç?

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-21 11:43 ½s¿è

¦^´_ 1# av8d

Selection.Sort Key1:=Selection, Order1:=xlAscending
©Î
Selection.Sort Key1:=Selection.Resize(1, 1), Order1:=xlAscending

TOP

¦^´_ 2# register313


    ¤j¤j¯u¬O¤Ó¼F®`¤F~½Ð°Ý¤j¤j~¦pªG¬O¿ï¨ú½d³ò¬OA3:C7ªº¸Ü~¥HCÄ滼¼W±Æ§Ç~¤S¸Ó¦p¦ó§ï¼g©O?

TOP

¦^´_ 3# av8d

Selection.Sort Key1:=Selection.Offset(0, Selection.Columns.Count - 1), Order1:=xlAscending

¥H©Ò¿ï¾Ü½d³ò¤§³Ì«á¤@Ä欰±Æ§ÇÁä§@»¼¼W±Æ§Ç

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2012-2-22 11:40 ½s¿è

¦^´_ 4# register313

Selection.Sort Key1:=Selection.Offset(0, Selection.Columns.Count - 1), Order1:=xlAscending
    ½Ð°Ý©Ò¿ïªº³Ì«á¤@Ä欰Offset(0, Selection.Columns.Count - 1
Á|¨Ò¦n¤F¡A¦pªG§Ú¿ï¤FABCÄæ©Ò¥H
0=CÄæ
-1=BÄæ
-2=AÄæ

TOP

¦^´_ 5# av8d

­Y¿ïA~CÄæ
Selection.Sort Key1:=Selection.Offset(0, 0), Order1:=xlAscending    ¥HAÄ欰±Æ§ÇÁä
Selection.Sort Key1:=Selection.Offset(0, 1), Order1:=xlAscending    ¥HBÄ欰±Æ§ÇÁä
Selection.Sort Key1:=Selection.Offset(0, 2), Order1:=xlAscending    ¥HCÄ欰±Æ§ÇÁä

TOP

¦^´_ 6# register313


­Y¿ïA~DÄæ
Selection.Sort Key1:=Selection.Offset(0, 0), Order1:=xlAscending    ¥HAÄ欰±Æ§ÇÁä
Selection.Sort Key1:=Selection.Offset(0, 1), Order1:=xlAscending    ¥HBÄ欰±Æ§ÇÁä
Selection.Sort Key1:=Selection.Offset(0, 2), Order1:=xlAscending    ¥HCÄ欰±Æ§ÇÁä
Selection.Sort Key1:=Selection.Offset(0, 3), Order1:=xlAscending    ¥HDÄ欰±Æ§ÇÁä

¥H¤W¬O§_¥¿½T?·PÁÂ!

TOP

¦^´_ 7# av8d

¥¿½T

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD