I have seen a lot posted about this but 99% of the discussion goes into
merged cells. I am not using merged cells.

What I am attempting to do is put error messages (that are short sentences
seperated with the CHAR(10) to force where I want the line to break.) from
code I am building a formula...

="SiteID must be numeric."&char(10)&"ItemPrice must be currency."

Which I want to put the result in 2(or more depending on how many error
messages are required) lines in the cell. But Autofit seems to randomly pick
where it wants to break the line which make the cell 3-7 lines in height.

How do I force the cells to autosize and properly break the lines where I
specify?

* Is there some way to calculate the required cell width of the longest
sentence in the column of cells? Perhaps I could force the column width =
to that value then. Of course that would require knowing the font size and
how much space is needed for the porportional font's characters.
* Is there some character (not a space or special character) that would
mimic a space in the text for calculating size then doing a replace on that
character back to a space after the column width is set. (special characters
seem to have a higher probability of causing a line break)
* Is there some trick to using autofit that I am missing?


--
Regards,
John