Hey team,
In this video I show you how to autofit row height and text wrap using basic VBA for both the entire worksheet and only a certain range, if desired.
Chapters:
0:00 Introduction
0:36 Autofit Row Height | Entire Workbook
1:06 Autofit Row Height | Specified Range
VBA Code for applying autofit row height to entire worksheet:
Cells.WrapText = True
Cells.EntireRow.AutoFit
VBA Code example for applying autofit row height to specified range (Remember to adjust first row of code to specify your desired range):
Set Rng = Range("A1:B100")
Rng.Cells.WrapText = True
Rng.EntireRow.AutoFit
