Replace in VBa

[Forestq]

Hi,

in Excel I'm using formula:

A2 = REPLACE(A1,1,FIND(":",A1),"").

Now in VBA I did like:

ws.Range("A2").Value =

"REPLACE(A1,1,FIND("":"",A1),"""")"

and it's ok.

How can I directly assign value from formula to my variable???
I had something like below but is wrong :/

Dim new_value as String
new_value = "REPLACE(A1,1,FIND("":"",A1),"""")"

 

[shg]

One way:

    Dim s As String
    
    s = Range("A1").Value
    s = Mid(s, InStr(s, ":") + 1)

 

[Forestq]

many thanks!!!!

 

[shg]

You're welcome.