Excel VBA : Appending string with a variable

[sachinns]

Hi Friends,

I have a string and a variable called "Formula". I want to append this string with my variable and update this value in the Cells(Lastrow, 3) of my active sheet.

String is :

“=IFERROR(IF(O9=” + Formula + " ;””);”Missing Leader Price”) "

Note : Orange part is my string

I tried to do it but its showing error. Can somebody help me to provide the vba code for this.

Thanks

 

[Fluff]

Glad you sorted it & thanks for the feedback.

I thought that you were trying to put the formula into the cell.