Gord,

It's not the point limit but I think it may be something to do with the
visible character per cell limit.

I have just done a character count on the visible text (visible text when
trying to use row autosize - clicking on line between rows) and it is
1,108chars including spaces, 924 without, which is fairly close to 1024.
The problem with your solution is that I have already got about 10 of
AT+ENTER's in this text already.

The cell's height won't autosize to show the entire text, but you can
manually size the row heights - this is time consuming though.

Regards

Andy


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Andi

Row height autosize is not limited to <14 rows of text. A row height is
limited to 409 points(72 points to the inch).

What you are most likely running into is the limits on viewable text in a
cell.

From Help on Specifications you will find that 32767 characters can be
entered
in a cell.

However, only 1024 of these will be seen or can be printed.

To get around this 1024 limit follow RD's advice and sprinkle some AT +
ENTER's in every 1000 chars or so.

Postings have indicated that you can increase the 1024 up to several
thousand.

Another work-around is to use a Text Box to store the text.


Gord Dibben Excel MVP

On Mon, 9 May 2005 15:55:43 +0100, "Andibevan"
wrote:

Hi All,

From my understanding, Excel's autosize feature for row heights has some
limitations as it only works on rows with 14 or less lines of text in a
cell.

I have two questions:-

1) Can anyone confirm the specifics of these limitations
2) Does anyone have any good ideas on how to workaround this (I am aware
that you can manually resize each row but as my sheet has over 700
entries
this would not be useable).

Any help or pointers would be gladly received.

Andi