using VBA to enter a R1C1 formula which contains double quotes "

[antaeusguy]

I want to enter a R1C1 style formula in range("A1") with:

=CONCATENATE(B1, " ",C1," ",D1)

I need to include a space between each cells with " ".

So I wrote this procedure:

Sub enterformula()
Range("a1").FormulaR1C1 = "=CONCATENATE(RC[1]," ",RC[2]," ",RC[3])"
End Sub

It says:
Compile error:
Expected: end of statement

and it highlighted this in blue ",RC[2]," --> showing me where the potential error is...

Does anyone here could help me with this problem? Thanks in advance

 

[Jonmo1]

You have to double up the quotes.

Try

Range("a1").FormulaR1C1 = "=CONCATENATE(RC[1],"" "",RC[2],"" "",RC[3])"

 

[repairman615]

Hello,
Welcome to the Message Board!

try:
<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> enterformula()<br>Range("a1").FormulaR1C1 = "=CONCATENATE(RC[1],"" "",RC[2],"" "",RC[3])"<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[antaeusguy]

Hey guys, thanks a lot for your great help, the vba worked!