auto adjust row height

jeffmfrank · Mar 5th, 2002, 04:39 PM

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 · Mar 5th, 2002, 05:23 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 04:39 PM	#1
jeffmfrank Board Regular Join Date: Feb 2002 Location: Arizona Posts: 72	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.

Mar 5th, 2002, 05:23 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	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 ]