Using Chr(10) and referencing cell

[deduwa]

Hi - I am having some problems with the following (which I am trying to solve in stages).

Ultimately I want to cell to read (spanning over 2 lines);

Final Score October (if weekly)
or September (if monthly)

The text 'October' sits in cell M2 of LastGame worksheet and is subject to change
The text 'September' sits in cell M3 of LastGame worksheet and is subject to change

In cell K1 of ActiveSheet, the following code works;

ActiveCell.FormulaR1C1 = "=CONCATENATE(""Final Score"" & "" "" & LastGame!R[1]C[2]) & "" (if weekly)"" & "" or"""

However, I want the word "or" to go onto the next line in the same cell. When I try the following, it returns #NAME ? in the cell;

ActiveCell.FormulaR1C1 = "=CONCATENATE(""Final Score"" & "" "" & LastGame!R[1]C[2]) & "" (if weekly)"" & Chr(10) & "" or"""

Once I resolve this I then want that second line to concatenate the word "or" with the month in cell M3 of LastGame worksheet and then followed by "if monthly"

 

[steve the fish]

Try this:

Range("K1").FormulaR1C1 = "=""Final Score ""&Lastgame!R2C13&"" (if weekly)""&CHAR(10)&""or ""&Lastgame!R3C13&"" (if monthly)"""

 

[deduwa]

Thanks Steve - that mostly works. However the output appears only on 1 line and not 2. I changed the CHAR to Chr and that still didn't work.

 

[Fluff]

Select the column & click "Wrap Text" on the Home Tab

 

[deduwa]

That worked. Thanks

 

[Fluff]

Glad we could help & thanks for the feedback