ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦C増´î

¦C増´î

³øªí¦C¼Æ¥i§_¨Ì¨Ó·½¸ê®Æ増´î¡AÁÂÁ¨ó§U¡C ½Æ»s -9801010630co2.rar (119.18 KB)

ÁÂÁÂMINª©¥D
                      ¤W¥h¬Ý¤F¤å³¹ÁÙ¬O¤@ª¾¥b¸Ñ¡AµLªk¦Û¤v¸Ñ¨M°ÝÃD¡A¥i§_°µ­Ó¹ê¦CÅý§Ú¥[³t¾Ç²ß?ÁÂÁÂ

TOP

PD961A ÁÂÁ¥ܱиg´ú¸Õ»P§Ú·Q­nµ²ªG¦³¤£¦P¡A¥i¯à¬O§Úªí¹F¤£¦n¦A»¡©úSheet1!O2:O35565(¨C¦¸¼Æ¶q¤£¤@¼Ë)COPY¦ÜSheet2!B5¡A¦V¤U¶K¤W¨Ã増´î¦C»PSheet1!O2:O35565¦³¸ê®Æ¦C¼Æ¦P¡A ¦A±NC5:AY5 ¤½¦¡¦P®É¦V¤U¶K¤W¡C

TOP

Hsieh ª©¥DÁÂÁ¸g´ú¸Õ§¹¥þ¥¿½T,¤£¦n·NÃѧڦbªþÀɤ¤§âsheet2  z5§Yµ{¦¡º¿ar(24)»~­È¬°¸Ó¦C²Ä¤@¦ì,¥¿½T chm.rar (28.01 KB) ¬O³Ì¤j­È,¨ä¾l»Ý¨D¦pªþÀÉ»¡©ú¡A·q½Ð¨ó§U¦A¦¹·P®¦¡C

TOP

HSIEH¥S
           Ar(24) = mystr(UBound(mystr)): Ar(26) = Val(Mid(mystr(0), 1, 2)): Ar(27) = Mid(mystr(0),
Ar(26)­n§ï¨úAr(24) = mystr(UBound(mystr)): ªº¥ª°_2¦ì,¦p23045¨ú23ÁÂÁ«ü¾É

TOP

¸g§ó§ï Ar(26) = Val(Mid(Ar(24), 1, 2))¥i¥H²Å¦X»Ý¨D¡A¥H¤WÁÂÁ¤G¦ìª©¥D¡C

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD