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

[µo°Ý] ¦p¦ó¨Ï¥Î°Ñ·Ó­¶¨Ó¨ú¥N¯S©w¦r¦ê

[µo°Ý] ¦p¦ó¨Ï¥Î°Ñ·Ó­¶¨Ó¨ú¥N¯S©w¦r¦ê

½Ð°Ý¦p¦ó§ó§Ö³t¨Ï¥Î°Ñ·Ó­¶¨Ó¨ú¥N¯S©w¦r¦ê

§Æ±æ³z¹L "¤H­û½s¸¹"¹ï·Ó"½s¸¹"¨Ó¨ú¥N,¹F¨ì"¤H¦W¹ï·Ó"®ÄªG

¥Ø«e¨Ï¥Îªº¨ú¥N¤è¦¡¬°
Worksheets("¤H­û½s¸¹").Columns("B").Replace _
What:="D00024", Replacement:="¨ª²Q­^", _
SearchOrder:=xlByColumns, MatchCase:=True

µ¥©ó­n¨C­Ó½s¸¹³£¶·«Ø¥ß¨ú¥N
½Ð°Ý¯à§_¦³§ó¦³®Ä²v¹F¨ì½d¨Ò¸Ìªº®ÄªG?

TEST.zip (9.99 KB)

·PÁÂAndy¤jªº¸Ñµª¡A¹ê´ú¨S°ÝÃD~
¾ã­Ó¶Wºë²¡A¤ÓÁÂÁ±z¤F¡C

TOP

½Ð°Ýhcm19522¤j,³o¬q¨ç¼Æ§@¥Î¬°¦ó?§Ú±a¤Jªí¤¤¥X²{¿ù»~...

TOP

Andy2483¤j §ïªº¹ÎÁÊ©ú²Ó¤]«Ü¹ê¥Î¡A¥ý°O¤U¤F~

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD