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

[µo°Ý] SUBSTITUTE-VBA¨Ï¥Î¤è¦¡½Ð±Ð

«ØÄ³¤W¶ÇÀÉ®×~~

TOP

Dim xR As Range
Application.ScreenUpdating = False
For Each xR In Range([A2], [A65536].End(3))
    If xR = "T45" Then Range(xR(1, 2), xR(1, 4)).Replace "¦¨«¬", "Äé¤Õ", Lookat:=xlPart
Next

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD