Syntax for formulas using & and ""

**RuthEllen63** · 11-02-2020, 03:19 PM

Hello,

This line of my code works: Range("M2:M" & lastrow).Formula = "=J2&"": ""&K2"

This one does not: Range("J" & (row - 1)).Formula = "=L""&(row-1)&Char(10)& ""L"&(row)""

Clearly I don't understand how to build these formulas and I can't seem to find online examples or tutorials.

I appreciate your help with this.

Thanks,

Ruth

**Bernie Deitrick** · 11-02-2020, 03:45 PM

Ruth,

Try this version:

Range("J" & (row - 1)).Formula = "=L" & (row - 1) & "& Char(10) &" & "L" & (row)

This is the same, with some simplification of the string manipulation:

Range("J" & (row - 1)).Formula = "=L" & (row - 1) & "& Char(10) & L" & (row)

Both concatenate two cells with a return character to get them to wrap within the cell - not sure if that is what you want.

**RuthEllen63** · 11-02-2020, 03:55 PM

They both work!

Thanks Bernie!

Ruth

Syntax for formulas using & and ""

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View