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