I notice that the Auotfit of row height does not work from time to time.
Can someone advise me how to resume this feature.

Thanks,

Scott

If the "time to time" involves merged cells that is a limitation of the
feature. It ignores them. Other than that, and obvious stuff like
protected sheets, you'll have to be more specific.

--
Jim
"Scott" wrote in message
...
|I notice that the Auotfit of row height does not work from time to time.
| Can someone advise me how to resume this feature.
|
| Thanks,
|
| Scott
|
|
|

If the row has been manually set to a height, you will have to reset under
RowsAutofit.

Or you have merged cells as Jim suggests.


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 10:46:58 +0800, "Scott"
wrote:

I notice that the Auotfit of row height does not work from time to time.
Can someone advise me how to resume this feature.

Thanks,

Scott