I am trying to write vba code that will look up a letter in a string and replace it with a specific cell value.
Problem is that the letter may appear in the string a maximum of 3 times and each time the letter needs to be replaced by different value.
I have x and x and x
The first x should be replaced with 1, second with 2 and third with 3.
My code so far
for i = 0 to lim range("B" & lim 13).Value = replace (range("B" & lim 13), "x",range("K" & lim 13).Value) Next i
The problem with above code is that this will replace each
x with the same value; I would like to make it with a specific order of replacement.
Ideally the second and third replace would come from a different cell value of my choice.