Replace word with variable

[Infine]

Hello,

How do I replace a word with a variable? For instance:

Column 2: "Hello, I am trying to code this script"

Then a code which is changing "trying" to $variable


Is it possible to try to search for a specific word, then replace this word with a variable and that variable is SET by you in the VBA code?

 

[davesexcel]

Use find/replace

 

[Joe4]

Something like this?

Sub MyReplaceMacro()

    Dim newVar As String

'   Prompt user for new variable
    newVar = InputBox("Enter the new string")

'   Replace "trying" in column B with inputted value
    Columns("B:B").Replace What:="trying", Replacement:=newVar, LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
        
End Sub

 

[Infine]

Thanks. Did not know you could use a replacement on variable. Stupid of me not trying before asking but thanks :D

 

[Joe4]

You are welcome.