¼ÐÃD:
EXCEL2010 ¥¨¶°¸Ì¦³¤¤¤åÃø¦rÅã¥Ü°ÝÃD...
[¥´¦L¥»¶]
§@ªÌ:
cypdju
®É¶¡:
2017-11-7 11:08 AM
¼ÐÃD:
EXCEL2010 ¥¨¶°¸Ì¦³¤¤¤åÃø¦rÅã¥Ü°ÝÃD...
Sub §ø§O±Æ§Ç()
ActiveWorkbook.Worksheets("²M¥U").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("²M¥U").Sort.SortFields.Add Key:=Range("D2:D30"), _
SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:= _
"¤¤µØ§ø,??§ø,¥Á°ê§ø,«n?§ø" _
°ÝÃD´N¬O¤W±µ{¦¡½X¤¤¤å¦r§Î(¦pûi,ûº,ûß...)·|µLªk¥¿±`Åã¥Ü¥X²{ ? ¸¹¡A¸Ó¦p¦ó¸Ñ¨M¦¹°ÝÃD
§@ªÌ:
Smiler
®É¶¡:
2017-11-9 04:04 AM
¼ÐÃD:
°Ñ¦Ò¬Ý¬Ý!!
³o³q±`¬O¦]¬°±zªº¿é¤Jªk¿é¥X®É¡A¿é¥X¦r¤¸¶°¬O±Ä¥ÎUnicode½s½X¡A¦ý¬O¦bExcel¥¨¶°¤¤¨Ï¥Î¤FBIG5½XªºÃö«Y¡F
¦pªG±N¿é¥X¦r¤¸¶°§ï¦¨BIG5½X¡A±zÀ³¸Ó·|µo²{³o¨Ç¦r§ä¤£¨ì¡A¦]¬°¦bBIG5½X¤¤¡A³o¨Ç¦rÄÝ©óÂX¥R¦r¤¸©Î³y¦r¶°¸Ìªº½s½X¡A©Ò¥H¥²»Ý·f°t¥~¦r¶°©ÎÃöÁp³y¦rµ{¦¡¤~¯à¨Ï¥Î!
§@ªÌ:
cypdju
®É¶¡:
2017-11-9 04:36 PM
·PÁ Smiler ªº¸Ñ»¡...¥²»Ý·f°t¥~¦r¶°©ÎÃöÁp³y¦rµ{¦¡¤~¯à¨Ï¥Î
¬O§_¦w¸Ë¥~¦r¶°´N¥i¦æªº·N«ä¶Ü?
§@ªÌ:
Smiler
®É¶¡:
2017-11-10 12:09 AM
¼ÐÃD:
°Ñ¦Ò¬Ý¬Ý!!
°ò¥»¤W¥un¿é¤Jªk¬D¿ï¥X¨Óªº¦r¶°¯à¥¿½T¹ïÀ³¡A¶Ç¦^ªºÅܼƴN·|¬O¥¿½Tªº¡F
°O±o¿é¥X¦r¤¸¶°¬O¥i¥H¨Ï¥Î¤¤¤å¼Ð·Ç¥æ´«½X¥þ¦r¶°(CNS11643)¡A¦ý¬O§Ú¦bWin7Àô¹Ò¤¤¡A¦n¹³¬O¥u¯à¥ÎBIG-5½X¥[³y¦r©Î¥~¦r¶°¡A±z¥i¥H¦Û¦æ´ú¸Õ¬Ý¬Ý!
[
Last edited by Smiler on 2017-11-10 at 12:49 AM
]
§@ªÌ:
cypdju
®É¶¡:
2017-11-12 11:39 AM
·PÁ Smiler ªº²Ó¤ß¸Ñ»¡...
Åwªï¥úÁ{ ºô»Ú½×¾Â (http://centurys.net/)
Powered by Discuz! 2.5