Need help adding CONCATENATE formula to cell using VBA

[Jed Shields]

Hello all,

I'm trying to add a formula that adds the first and last names to a cell. It works fine but I'm having trouble adding a space between the names. Any ideas on the correct syntax?

Sub FullName()

Dim LastRow As Long
 LastRow = Range("AJ" & Rows.Count).End(xlUp).Row
Range("BH1").Select
    ActiveCell.FormulaR1C1 = "Full Name"
Range("BH2").Select
    ActiveCell.Formula = "=concatenate(C2&""&D2)"
'Range("BH2").Select
'    Selection.AutoFill Destination:=Range("BH2:BH" & LastRow)
Range("BH2").AutoFill Destination:=Range("BH2:BH" & LastRow)
End Sub

Cheers,

Jed

 

[Fluff]

Try

"=concatenate(C2&"" ""&D2)"

 

[Jed Shields]

Aaaaarrrrgggghhhhh!!! Quotes in quotes! It's the only combinination I didn't try! XD

 

[Fluff]

Glad to help &thanks for the feedback