Runtime error 1004 CONCATENATE

[hansgrandia]

Hello,

I would like to have a space between two cells N2 and O2. The " is a delimiter (right?). What is a workable option to use?
Very much appreciated!

Range("P2:P" & LastRow).Formula = "=CONCATENATE(N2, "", O2)"

Hans Grandia
The Ne

 

[Jonmo1]

When using VBA to enter a formula in a cell, and that formula contains quote marks, you have to double up those quote marks.

Try
Range("P2:P" & LastRow).Formula = "=CONCATENATE(N2, """", O2)"

 

[hansgrandia]

Thanks!