Board logo

¼ÐÃ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¥u­n¿é¤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://www.centurys.net/) Powered by Discuz! 2.5