Thread: [Solved] Find & Replace Unique word
View Single Post
 
Old 05-23-2017, 04:06 AM
raghugada raghugada is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2017
Posts: 21
raghugada is on a distinguished road
Default

As you said me earlier that tracking is not working for step replacement
so that u suggested me to use wildcards

this code is for non wildcards
Replace(exWb.Worksheets(1).Range("A" & i), "^", "^^")
and:
Replace(exWb.Worksheets(1).Range("B" & i), "^", "^^")