[RESOLVED] Replace string value in a string

[good4u]

Dear all,

i'm trying to make the following code work... but, something not understandable happens, ie when i'm trying to replace "01" in the the string "01020304050607080910111213", it doesn't only remove the "01" at the beginning but the "10" in the middle ??? Can anyone help ?

Sub toto1()
Dim valuetoreplace As String
valuetoreplace = "01"
Dim myval As String
myval = "01020304050607080910111213"
Dim mynewval As String
mynewval = Replace(myval, valuetoreplace, "")
Debug.Print mynewval
End Sub

Thanks in advance for any help !

[Justa Lol]

did you add Option Explicit in the top of the code?

[good4u]

Hi, thanks for the reply but no. Unfortunately, that doesn't solve the problem either. I really don't get it...

[5ms?]

You have two "01"

        "01"..............."01"
myval = "01020304050607080910111213"

"01020304050607080910111213"
'01'02030405060708091'01'11213

[good4u]

Gosh i'm stupid... of course... Too many hours in front of the pc... Thanks a lot, 5ms? (as well as to justa lol).