Auto Row Height in Merged Cells with pre exisiting text

[gwinder]

Cells A1:C1 are merged with wrap text. I have entered six lines of text and
row height automatically adjusted because I have the macro running to do this.

Cells D1:G1 are merged with wrpa text. I enter three lines of text and row
height automatically adjusts for this cell only hiding three lines of text in
A1:C1. How do I get to see all six lines?

Thanks,

Gary

 

[Dave Peterson]

You have a suggestion at your other post.

Cells A1:C1 are merged with wrap text. I have entered six lines of text and
row height automatically adjusted because I have the macro running to do this.

Cells D1:G1 are merged with wrpa text. I enter three lines of text and row
height automatically adjusts for this cell only hiding three lines of text in
A1:C1. How do I get to see all six lines?

Thanks,

Gary

 

[Gord Dibben]

If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP

Cells A1:C1 are merged with wrap text. I have entered six lines of text and
row height automatically adjusted because I have the macro running to do this.

Cells D1:G1 are merged with wrpa text. I enter three lines of text and row
height automatically adjusts for this cell only hiding three lines of text in
A1:C1. How do I get to see all six lines?

Thanks,

Gary

Gord Dibben MS Excel MVP