½Ð°ÝVBA°ª¤â¤j¤j~n¦p¦ó§ï¼g¤~·|§ó²³æ©öÀ´©O?
- ©«¤l
- 40
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office xp
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-17
- ³Ì«áµn¿ý
- 2013-1-28
|
½Ð°ÝVBA°ª¤â¤j¤j~n¦p¦ó§ï¼g¤~·|§ó²³æ©öÀ´©O?
½Ð°ÝVBA°ª¤â¤j¤j~
¥H¤U¬O°w¹ï¤u§@ªí(¥Dn)BÄæ¦ì¤Î(¦¸n)CÄæ¦ì±Æ§Ç»¼¼W
©Ò¿ý»sªº¥¨¶°,¬Ýªº²´ªá¼º¶Ã~~~
n¦p¦ó§ï¼g¤~·|§ó²³æ©öÀ´©O?
Sub Macro1()
'
' Macro1 Macro
' user ¦b 2013/1/15 ¿ý»sªº¥¨¶°
''
Range("A3").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Key2:=Range("C3") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, SortMethod:=xlPinYin, DataOption1:= _
xlSortNormal, DataOption2:=xlSortNormal
Range("H3").Select
End Sub |
|
|
|
|
|
|
- ©«¤l
- 40
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office xp
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-17
- ³Ì«áµn¿ý
- 2013-1-28
|
¦^´_ 1# alltest
sorry~§Ñ¤Fªþ¤W¹Ï¤ù
|
|
|
|
|
|
|
¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
¦^´_ 2# alltest
§AªºMS Office ¬O2003 ÁÙ¬O2007
¦L¶H¤¤ MS Office ¨SXP.. |
|
¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~
¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk
¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM
|
|
|
|
|
- ©«¤l
- 40
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office xp
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-17
- ³Ì«áµn¿ý
- 2013-1-28
|
ÁÂÁÂHsieh ¶W¯Åª©¥D¤j¤jªº¤£§[«ü±Ð~·P®¦^^
Åýªì¾Çªº§Ú,¦³Ó§ó¦nªº¾Ç²ß¤è¦V
§Æ±æ¦³¤@¤Ñ¤]¯à¦¨¬°VBA°ª¤â |
|
|
|
|
|
|
- ©«¤l
- 40
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 70
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office xp
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2012-12-17
- ³Ì«áµn¿ý
- 2013-1-28
|
¦^´_ 3# mark15jill
sorry~¬O 2003 |
|
|
|
|
|
|