Hello,
I'm using replace in VBA it looks like this:


VB:
Dim result As String
result = Replace(Range("d5"), "X", Range("f2"))
Range("k1") = result

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
This will look in d5 for X and replace it with f2. If instead of looking for X i want to look for the value in d4, how is it done? if i put range("d4") instead of X it doesn't work.

Thanks
K