ExcelBanter - expand row to fit

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - expand row to fit (https://www.excelbanter.com/excel-worksheet-functions/263224-expand-row-fit.html)

Peter

expand row to fit

Is it possible to format a cell / row so that if the text in a cell is longer
than the width the text wraps and the row height expands to include the extra
line(s)?

Thanks,
Peter.

Gord Dibben

expand row to fit

FormatCellsAligmentWrap Text

FormatRowAutofit.

Note: if cells are merged the row autofit won't work.

Gord Dibben MS Excel MVP

On Wed, 5 May 2010 15:06:01 -0700, Peter
wrote:

Is it possible to format a cell / row so that if the text in a cell is longer
than the width the text wraps and the row height expands to include the extra
line(s)?

Thanks,
Peter.

bala_vb

Quote:

Originally Posted by Peter (Post 951620)

Is it possible to format a cell / row so that if the text in a cell is longer
than the width the text wraps and the row height expands to include the extra
line(s)?

Thanks,
Peter.

Try this on workbook_open event

Worksheets("Sheet1").Range("A1:A65000"). _
AutoFormat Format:=xlRangeAutoFormatClassic1

it will autoformat.

All times are GMT +1. The time now is 10:03 AM.