Wrap Text and FormatRowsAutofit should do what you want.

If a row has been manually set to a height, it will not expand untill you have
reset to Autofit.

UNLESS you have merged cells, in which case Autofit won't work and rows have to
manually adjusted or adjusted by sheet event code.

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Thu, 5 Jun 2008 06:23:02 -0700, clara
wrote:

Hi all,

Why does Text Wrap produce two results when a cell holds long text string:
sometime a cell is expended vertically and sometime a cell height keep same.
I am using the 2000 version


Clara