Quote:
Originally Posted by Peter
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.