auto adjust row height

[jeffmfrank]

assuming the column width is fixed, and text can wrap in the cells. Is there a way to have the sheet automatically autofit the row heights when the values in the cells change because their precendents change? Thanks.

 

[Paul B]

Not automatic but you can go to format, row, AutoFit

You could use this marco put it in your sheet code and change the range to fit

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Range("A:A").Rows.AutoFit
End Sub
This message was edited by paul b on 2002-03-05 20:12