Nope. I don't open unsolicited workbooks.

But I looked at the code that Jim posted:
http://groups.google.com/groups?thre...%40tkmsftngp05

And saw this portion.

.RowHeight = IIf(CurrentRowHeight PossNewRowHeight, _
CurrentRowHeight, PossNewRowHeight)

This says to not adjust the rowheight if the current row height is larger than
the possible new row height.

Maybe you made a change that broke this?????

gwinder wrote:

Dave....I copied the macro from Jim Rech I think so I don't really know how
to make the change you're suggesting. If I emialed the worksheet to you
could you take a look at it please?

Thanks,

Gary



"Dave Peterson" wrote:

Maybe you can change your macro to only increase the rowheight. (If the
rowheight after your routine would be smaller than the existing rowheight, then
don't change it.)



gwinder wrote:

I have applied a macro to automatically adjust the row height when entering
text into merged cells. It works fine when the whole row has no text in it.
However, when I enter text into a blank cell that is in a row that has text
in it, the row height adjusts to the amount of text I enter in the blank
cell, not the height based on how much text is in the cell next to it.

Cells A1:C1 are merged and wrap text. I have entered six lines of text
which has automatically adjusted the row height to fit.

Cells D1:H1 are merged and wrap text. I have entered three lines of text
which now automatically adjusts the row height hiding three lines of text
from A1:C1. How do I get all six lines to to show?

Thanks,

Gary

--

Dave Peterson


--

Dave Peterson