I am thinking it may be best to just create this helper column and send it
out to column EE or something just really far from our work. I already tested
that on one sheet and it worked exactly as I hoped. I do prefer a coding
method if possible though as it doesn't eat up a column that may get messed
with some day or forgotten about..

The thing is: 23 sheets, each with several hundred rows (some merged), and
an index with a summary of everything. Every single row contains a
comments/suggestions cell - and for the most part this has always fit in a
cell 300 pixels long and two lines tall. This is becoming infeasible as we
expand into other areas as we are having more than one person leave comments
or suggestions. So this would need to work on every row I already have as
well as any new ones.

If you know of a way to do this code wise, great - but the helper column
will suffice until Office 2010 (hopefully) haha.

Thank you for the suggestion!


"Dave Peterson" wrote:

You could add a helper column that contains enough text to insure that
autofitting the rowheight will never be smaller than what's required for the
cell in that column.

You could even hide that column.

Another way is to use an event macro that autofits the rowheight and then
adjusts the rowheight if it's not what you like.

But that event macro would depend on the details.

How is the cell changing--by formula or by manual entry by the user?
How many worksheets in this workbook need this?
What rows/cells need this on each sheet?