Hi,

I am having trouble inserting a formula to concatenate two cells into
another cell with a comma separating them.

Here is one of my attempts:

MainPage.Select

With MainPage
Range("BA").Select
ActiveCell.formulaR1C1 = "= R" & NextRow & "C3" & "&" & "," _
& "&" & "R" & NextRow & "C4"
End with

What am I missing?

Thanks