ASCII character for hard return in VBA excel

[shornco]

I'm writing text for a cell in VBA code. I want a hard return in the middle of my sentence and can't find the right combination of ASCII characters. In Access I've always used the combination Chr(13) & Chr(10), but both of those characters are giving me the box symbol in the middle of my text. This is what I have:

ActiveCell = "This is my first row of text" & Chr(13) & Chr(10) & "this is my second row of text."

I've also tried Chr(13) by itself and Chr(10) by itself. Any ideas?

 

[Norie]

Try formatting the cell to wordwrap.

Cells>Format>Alignment and check Wrap Text.

 

[PA HS Teacher]

I use Chr(10) for a hard return all the time. I think Norie's right. When a cell is not formatted to be wrapped, the hard return shows up as that square symbol.