Line breaks appear as squares in comments

G

Gustaf

Using Excel 2007, and doing some work in VBA to add comments in certain cells. My problem is that at each line break, there is an outlined square. Have tried vbLf, vbCr, vbCrLf and vbNewLine and they all give the same result.

To be more specific, I use the XML DOM classes to create an XML document with line breaks in, but I don't think that should matter. A sample:

Set objElement = objDom.createElement("value")
objElement.Text = remoteCell.Value
objRoot.appendChild objDom.createTextNode(" ")
objRoot.appendChild objElement
objRoot.appendChild objDom.createTextNode(vbNewLine)

Gustaf
 
J

joel

Make sure Wrapped Cells are enabled.

from worksheet menu
format - Cells - Alignment - Wrap Text

Columns("A").WrapText = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Parse cells with line breaks 4
Restoring line breaks in memo field 2
Creating a line break (newline) in a cell with SpreadsheetML 0
Writing File in VBA with Unix line break 3
Line breaks in Excel 2
Inserting line breaks in outlines 12
Line breaks and print errors 2

Top