After reading through all the row height responses (most of which address
mergred cells - not my issue), I don't see where this has been addressed. I
have a formula that can retrieve a highly variable amount of text. Since
that cell is never directly edited, it does not trigger autofit to resize the
row height. If I double-click on the lower border of the row, or invoke
Autofit manually, it does resize the row. But I need that to happen
automatically (so I don't get calls from users telling me that text is
missing). This could make the solution easier: all the changes that would
increase/decrease the amount of text in the cell happen on another worksheet,
so maybe all I need is an event macro that invokes Autofit when returning to
the target sheet.

I am using xl2003, and the target sheet is password protected.

TIA