Auto Fit

[Trevor2002]

Hello,
I have cells A1:H1 merged into one cell and set to wrap text. In this cell I need to type a text message, sometimes the message will fit in these merged cells and sometimes it won't depending on the size of the message. I would like to expand row 1 automatically, if needed to accommodate the size of the message. I tried auto fit and can't seem to get it to work.
Thanks Trevor2002

 

[VoG]

Try this: Right click the sheet tab and select View Code, paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Target.Columns.AutoFit
End Sub

then close the code window using the X.