Auto expand row

[Foxy Lady]

Hi there,

I need to auto expand a row - I added the wrap text option but the row doesn't expand to adjust when the sentence becomes to long for the column.

Thanx in advance

 

[sijpie]

Is this just on a spreadsheet, or are you wanting to code this into a macro?

in the spreadsheet, check that the row height is set to fit. (Format/row/height)


To see how itis done in a macro, record a macro while you do this.

 

[daverunt]

For the spreadsheet click on the top of the column you want to auto fit.
On the Home Tab select Format in the Cells block - Auto Fit Column width.
(xl 2007)

For a macro you need to add this for the appropriate column

Range("A:A").Select 
Selection.Columns.AutoFit