Autofit does not work with merged cells.

There is a solution........DO NOT USE merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Also revised code for special cases.

http://snipurl.com/dfsm


Gord Dibben MS Excel MVP

On Wed, 19 Jul 2006 08:34:02 -0700, rstrefry
wrote:

Text wrap is True. The cells are merged...I read in previous submittals that
might be my problem. Is there a solution?

"Greg Wilson" wrote:

1. Have you set WrapText to True? (Format Cells Alignment tab Wrap text)
2. Is the cell merged?

Greg

"rstrefry" wrote:

I cannot seem to get the row height Autofit function to work when typing text
in Excel. When in the cell or cells I want to expand automatically and go to
format rowauto fit the cell shrinks to one line though I have typed
multiple lines of text. How do I get it to expand to show all the lines
automatically?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions