[µo°Ý] »¼¼W±Æ§ÇA1~A10¡A¦p¦óÅýA1«á­±¬OA2¦Ó¤£¬OA10¡C

av8d

1. 'A:F»¼¼W±Æ§Ç
   
2.     ActiveSheet.Columns("A:F").Select
   
3.     Selection.Sort Key1:=ActiveSheet.Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
   
4.         OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
   
5.         :=xlStroke, DataOption1:=xlSortNormal

½Æ»s¥N½X

¥H¤W¬O»¼¼W±Æ§Çªº¥¨¶°~
¦ý¬O±Æ§Ç«á~¸ê®Æ¤º¦³A1.XXXXX~A10.XXXXXXX
»¼¼W±Æ§Ç~«o¬O
A1.XXXXX
A10.XXXXX
A2.XXXXXXX

¦p¦óÅý¥¦Åܦ¨
A1.XXXXXX
A2.XXXXX

av8d

¦^´_ 3# Hsieh


    ¥Ñ©óCÄæ°£¤F¦³A1~A20¥~~ÁÙ¦³B1~B20~©MC1~C20µ¥...
¦pªG§Ú±NtestÁôÂÃ~¬O§_¥i¥H°w¹ï¥L±Æ§Ç©O?ÁÂÁÂ!

av8d

¦^´_ 5# GBKEE


    §Úªº¬O2010ª©~¥i¬O§ä¤£¨ì¿ï¶µ->¦Û­q²M³æ->¶×¤J

§Ú°O±o¥H«e¦³¨Ï¥Î¹L~§Ú¦A§ä¬Ý¬Ý^^ ÁÂÁÂG¤j!

av8d

¦^´_  GBKEE


    §Úªº¬O2010ª©~¥i¬O§ä¤£¨ì¿ï¶µ->¦Û­q²M³æ->¶×¤J

§Ú°O±o¥H«e¦³¨Ï¥Î¹L~§Ú¦A§ä¬Ý¬Ý^^ ...
av8d µoªí©ó 2012-8-19 21:46

    §ä¨ì¤F~¿ï¶µ->¶i¶¥->½s¿è¦Û­q²M³æ~ÁÂÁÂG¤j!

av8d

¦^´_ 5# GBKEE


    ¦n¹³¤£¯àA1~A20¥BB1~B20¥BC1~C20~
¬O¦]¬°¹Lªø?

av8d

¦^´_ 9# Hsieh

¦pªG¬O¤@¯ë
1.XXXX
2.XXXX
8.XXXX
11.XXXX

«ç»ò±Æ§Ç«o¬O
1.XXXX
11.XXXX
2.XXXX
8.XXXX

av8d

¦^´_ 12# Asterl


    A¤j~ÁÂÁ§A~¾Ç²ß¤F^^