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

[µo°Ý] ¶ñ¤J¼t¯Ê&µù¸Ñ

¦Ò¼{¨âÀɪº[°Ó«~]¤Î[¾P°âÂI]¦WºÙ©Î¦ì¸m¥i¯à¤£¤@­P, ©Ò¥H¼g±o½ÆÂø,
¦³°ÝÃD¦Û¦æ¥h­×§ï:
¶ñ¤J¼t¯Êv01.rar (163.8 KB)

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-4-26 10:22 ½s¿è

¦^´_ 4# PJChen


1)  xR = "=" & Val(xR) & "-" & Arr(i, j)
    ©Î xR = "=" & IIf(Val(xR) = 0, "", xR) & "-" & Arr(i, j)

2)  FN = "¤ë®w¦sªí.xlsx"

TOP

¦^´_ 7# PJChen


Set Sht = ActiveSheet

TOP

¦^´_ 13# PJChen


ÀɮצWºÙ¥Î«ü©wÀx¦s®æ¿é¤J¤º®e¨Ó¦s¨ú~~

TOP

¦^´_ 17# PJChen

Á`¬O¬Ý¤£À´³W«h, ºN¯Á°µ, ¦Û¦æ¥h­×§ï:
¸ü¤J¹L¤¹¤é¦Lv01.rar (190.13 KB)

TOP

¦^´_ 19# PJChen


Á`¬Ý¤£À´»Ý¨D³W«h, ¦Û¦æ§ï§ï:
¸ü¤J¹L¤¹¤é¦Lv02.rar (179.24 KB)

TOP

¦^´_ 21# PJChen


ÁöµM»¡©ú¦h¦¸, ¦ýÁÙ¬O§Ë¤£À´, ¤@°ï¤å¦r¬Ý±o²´ªá,
µ{¦¡½X¤w¾¨¶q¤À¶}¼g§PÂ_, µ¹¤F¤èªk, ­Y³£µLªk²z¸Ñµ{¦¡½X¦Ó¦Û¦æ­×§ï,
³o¼Ë¤j®a³£¦£¤£§¹~~

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD