Rows expand to fit text typed in?

[Amy]

Hi - I have my cells set up to wrap text. However, even with that, the row
height (which is not set to fixed height), does not expand to fit the text
typed in. Is there a way in which I can get to "auto-expand" to fit whatever
is typed into the row without just setting a really big fixed height? Thank
you!

 

[Dave Peterson]

You could use an event macro.

Rightclick on the worksheet tab that should have this behavior, select view code
and paste this into the code window.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Target.EntireRow.AutoFit
End Sub

 

[Gord Dibben]

If the cells are "merged" autofit won't happen.........even with Dave's
event code.

If that is the case......................

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