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

VBA¤½¦¡""Åã¥Ü°ÝÃD

VBA¤½¦¡""Åã¥Ü°ÝÃD

¤j®a¦n

§Ú·Q±NA1ªºÀx¦s®æ³]¬°¥H¤U¤½¦¡
Worksheets("Main").Range("A1").Formula = "=IF(RIGHT($C1,6)="000000","-",LEFT($C1,6))"
¥i¬O" "ªº¸Ì­±ÁÙ¦³""·|¥X²{¿ù»~
½Ð°Ý­n«ç¼Ë¤~¯à³]©w¤½¦¡""¸Ì­±ÁÙ¦³""
ÁÂÁÂ

Worksheets("Main").Range("A1").Formula = "=IF(RIGHT($C1,6)=""000000"",""-"",LEFT($C1,6))"
Jess

TOP

¦^´_ 2# jesscc


    ·PÁÂ~­ì¨Ó¬O""¥~­±­n¥Î""¥]µÛ

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD