Wrapped cells don't print all the rows.

**aresquare1** · 03-23-2024, 11:55 AM

I posted this in General but they said it's only done with VBA. Here was my post. Is there a way to autofit the row height to whatever a number is in that row without VBA? e.g. if cell B14 has the numeral "40" in it, can I autofit row B to 40 without VBA? I am using Excel 365.

So, my question in this VBA forum is what would the code be to do that and does that code need to be added to every sheet or the ThisWorkbook object in VBA?

Thanks,
RR

**6StringJazzer** · 03-23-2024, 12:18 PM

Your question is not clear. If B14 has the number "40" in it, there is no wrapped text and the row height will autofit.

Please provide a sample workbook showing sample data, how it is formatted immediately upon entry, and how you want it to look after the row height adjustment.

**alansidman** · 03-23-2024, 02:14 PM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #2 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...-that-row.html

Thread closed.