Autofit Row

[hedgie]

I have a cell (Say M5) that Conatenates some text based on the answer to another cell (Say M2). Based on this, the cell autowraps text so that it may need to be 2 rows in height or not. I would like the autofit row to automatically adjust the row size based on any changes to M2.

Any thoughts?

 

[VoG]

Maybe

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Address(False, False) <> "M2" Then Exit Sub
Target.EntireRow.AutoFit = True
End Sub