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

[µo°Ý] ¦p¦ó¨Ï¥ÎVBA¨ú±o©w¸q¦WºÙªº½d³ò

[µo°Ý] ¦p¦ó¨Ï¥ÎVBA¨ú±o©w¸q¦WºÙªº½d³ò

½Ð±Ð !  ¦p¦ó¨Ï¥ÎVBA¨ú±o©w¸q¦WºÙªº½d³ò, ¶ñ¨ìÀx¦s®æ I1

Name.png (191.84 KB)

Name.png

Name.zip (7.75 KB)

¦^´_ 1# ABK
½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Sub test()
For Each Ne In Names
    n = n + 1
    Cells(n, 9) = Replace(Ne, "=", "")
Next
End Sub

TOP

¦^´_ 2# samwang
ÁÂÁÂ samwang¤j !

µ²ªG ¦h¤F 1­Ó

Name_1.png (156.96 KB)

Name_1.png

TOP

¥»©«³Ì«á¥Ñ samwang ©ó 2022-5-5 13:56 ½s¿è
¦^´_  samwang
ÁÂÁÂ samwang¤j !

µ²ªG ¦h¤F 1­Ó
ABK µoªí©ó 2022-5-5 13:10


¨ºÀɮצ³1­ÓÁôÂêºname¡A§Ú¥t¥~copy¸ê®Æ¨ì·sÀɮסA°õ¦æok¦pªþ¥ó¡A½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

1.JPG (127.81 KB)

1.JPG

¬¡­¶Ã¯1.zip (12.67 KB)

TOP

¦^´_ 4# samwang
¦nªº!
ÁÂÁÂ samwang¤j !

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD