Range Replace? Correct syntax?

[passinthru]

In an old thread, I found what seems to be the solution I'm looking for, but I'm having trouble with the syntax. Member doofusboy suggested:

Range(your_cell_address_here).Value = Replace(Replace(Replace(Replace(Range(your_cell_address_here).Value," ","_"),"-",""),"(",""),")","")

This seemed to work for the OP on that thread.


However, when I try it in a macro, I get a "Type Mismatch" error.

Here's my code:

Range("A1:A2000").Value = Replace(Replace(Range("A1:A2000").Value, "ms TTL", "|ms TTL"), "time=", "time=|")


This is the first line of code, and it croaks right there. No joy.Can someone tell me what obvious mistake I've made?

The regular Search & Replace is not reliable, for reasons I mention in the original thread.

 

[shg]

' dummy find to reset retained state
Range("A1").Find What:="Texas", _
                 MatchCase:=False, _
                 MatchByte:=False, _
                 SearchFormat:=False
 
Range("A1:A2000").Replace What:="ms TTL", _
                          Replacement:="|ms TTL", _
                          LookAt:=xlPart, _
                          ReplaceFormat:=False
Range("A1:A2000").Replace What:="time=", _
                          Replacement:="time=|", _
                          LookAt:=xlPart, _
                          ReplaceFormat:=False

 

[passinthru]

Dot verks!

Thank you!


I like this method better, too. Multiple nesting can get confusing.


Bit of a kludge that the required setting isn't available in the search/replace code, isn't it?