line break

[288enzo]

Hello, In the below code, how would I go about adding a line break where there is a space?

Range("C3").Value = "First Second Third"

In C3 I would like for it to look like:
First
Second
Third

Thank you!

 

[gigidica]

I don't know if this is what you are looking for but try:

ActiveCell.FormulaR1C1 = "First " & Chr(10) & "Second" & Chr(10) & "Third"

Thank you

 

[288enzo]

I don't know if this is what you are looking for but try:

ActiveCell.FormulaR1C1 = "First " & Chr(10) & "Second" & Chr(10) & "Third"

Thank you

Thank you, that certainly gave me what I was looking for.

Range("C3").Value = "First" & Chr(10) & "Second" & Chr(10) & "Third"