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

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

«Øij¤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 : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD