Help with 1 vba formula - Not Working

[Johnny Thunder]

Having an issue with a formula in VBA.

I am also confused as too why additional quotation marks are needed when using formulas in VBA code?

Line:

.Range("L4:L" & LR).Formula = _
"=$D$9 & " " & $D$8&" " &FCSTNAME& " " vs. "&$D$9 & " " & $D$8&" " &VERPRIORDESC"

 

[Fluff]

Try

.Range("L4:L" & lr).Formula = "=$D$9 & "" "" & $D$8 & "" "" & FCSTNAME & ""  vs. ""& $D$9 & "" "" & $D$8 & "" "" & VERPRIORDESC"

 

[Johnny Thunder]

Worked great, thanks for the help.

Try

.Range("L4:L" & lr).Formula = "=$D$9 & "" "" & $D$8 & "" "" & FCSTNAME & ""  vs. ""& $D$9 & "" "" & $D$8 & "" "" & VERPRIORDESC"

 

[Fluff]

Glad to help & thanks for the feedback