I don't know if this will help, but these are the limits prior to xl2007.

You can enter a row height of 0 (zero) to 409. If the row height is set to
0, the row is hidden. You can enter a column width of 0 (zero) to 255
characters. If the column width is set to 0, the column is hidden.

Generally speaking, the autofit and word wrap functions should set the width
and heigth to accomodate whatever you enter that are within the above
limitations.

"Trevor Williams" wrote:

Hi All

I need to set the row height depending on the number of lines of text
contained in a cell. Cells that contain text have wordwrap on - if there is
only 1 line of text in the cell the row height should be 12.75, 2 lines of
text should be 22.50 and so on.

Is it possible to determine how many lines of text are in a cell?

Thanks

Trevor