- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 13# PJChen
2010ª©
¥Î8¼Óªºµ{¦¡§Y¥i
µ{¦¡²Ä1¦æ³Ì«á¤Ö¤F ªÅ¥Õ »P _
.Range("A1").CurrentRegion.Sort Key1:=.Range("D2"), Order1:=xlAscending, _
¦A¸Õ¸Õ¬Ý
©Î- Sub xx()
- Ar = Array(5, 4, 3, 2, 1) '±qÀu¥ý¶¶§Ç³Ì§CªºÄæ¦ì¶}©l,n±Æ´XÄæ¬Ò¥i
- For i = 0 To UBound(Ar)
- [A1].CurrentRegion.Sort Key1:=Cells(2, Ar(i)), Order1:=1, Header:=xlGuess '1:»¼¼W 2:»¼´î
- Next
- End Sub
½Æ»s¥N½X |
|