new line within cell text

[ffffloyd]

I am unsure which category to post this in, and so am cross posting this question under Excel Programming also.

When I want to force a new line within a cell, I can do it as I am typing by hitting alt-Enter. No problem.

However, if I want to do it programmatically, I would expect CHAR(10) to cause a line break. If not that then CHAR(13)&CHAR(10). However, no combination of these characters seems to enforce the line break; they just produce a continuous line of output with little rectangles where the unprintable characters appear.

My question: how do I enforce a new line programmatically within the text of a cell?

[stanleydgromjr]

ffffloyd,

See several answers in your other post:
http://www.excelforum.com/excel-prog...cell-text.html

[mudraker]

Also please Note forum rules

5. Don't duplicate posts. We have seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one.

[ffffloyd]

The answers in the other post aren't what I was hoping for. As I said, I was unsure which category to post the question in.

[ffffloyd]

Solved finally by shg in the cross-post.