Any merged cells involved?

If so, remove them or you will be forced to use Event code to autofit rows.

For the code, post back.


Gord Dibben MS Excel MVP


On Thu, 10 Apr 2008 12:34:00 -0700, Odie wrote:

I am trying to make the height of a row change automatically. I know that
formatrowautofit should accomplish that, but for some reason it is not
working. I have formatted the cells I need to word wrap. Several of the
cells in the row are formatted for numbers or date entry. What am I doing
wrong?

I have used the autofit function before, but it never seems to autofit the
row height consistently. Sometimes it will work and other times it won't.

I hope someone can help me. Thanks.