Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line breaks appear as squares in comments
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Line breaks appear as squares in comments
Make sure Wrapped Cells are enabled.
from worksheet menu format - Cells - Alignment - Wrap Text Columns("A").WrapText = True "Gustaf" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My comments on my excel spreadsheets print as black squares why? | Excel Worksheet Functions | |||
Line breaks | Excel Discussion (Misc queries) | |||
Line breaks | Excel Worksheet Functions | |||
removing squares and lines in squares that really should be paragr | Excel Discussion (Misc queries) | |||
removing hard breaks from comments or active cells | Excel Programming |