FormatRowAutofit.

Unless you have merged cells in the range.

In that case row autofit will not work and you must add event code to
autofit.


Gord Dibben MS Excel MVP


On Wed, 12 Aug 2009 07:34:02 -0700, Damian
wrote:

Well not the single cell but the whole row can right? I know I did it before.
When you type and its larger then the cell and you have wrap text it will
automatically expand the whole row to fit the text.

"Bernard Liengme" wrote:

A cell never expands when text is added (only when numbers are added and the
width has not been preset)
Wrap Text does nothing until you use ALT+ENTER to make a line break
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Damian" wrote in message
...
Probably an easy question, how can I make the cells expand automatically
to
fit the text. I have Wrap Text on but the cell does not expand.

Thanks