ExcelBanter - Using autofit on cells which include ASCII 10 (LF) character

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using autofit on cells which include ASCII 10 (LF) character (https://www.excelbanter.com/excel-programming/404857-re-using-autofit-cells-include-ascii-10-lf-character.html)

joel

Using autofit on cells which include ASCII 10 (LF) character

Auto fit the rows

"DartGuru" wrote:

I use MS Excel 2003 SP2.

I have cells which include the line feed character ASC 10.
So a cell might contain four lines of text (with three LFs).

When I use autofit, either coded or double-clicking on the horizontal
row separator, the row reduces to the width of a single row of text,
such that the remaining three rows are not visible.

Is there a way around this ?

All times are GMT +1. The time now is 04:33 AM.