Just saw a post from Dave Peterson that suggested to widen the column to 255,
then autofit...
that worked exactly like I want.
--
Regards,
John


"John Keith" wrote:

> 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