Excel vba autofit

' Autofits all columns / rows of the range
Range("MY_RANGE").EntireColumn.AutoFit
Range("MY_RANGE").EntireRow.AutoFit

' Autofits a single column / row
Range("MY_RANGE").Columns(1).EntireColumn.AutoFit
Range("MY_RANGE").Rows(1).EntireRow.AutoFit

Similar codes

22 votes557 views1 answer
Xl vba check for folder
VBA
0 vote250 views2 answers
Excel vba number format file size
VBA
5 votes255 views1 answer
Vba low byte from INTEGER
VBA
0 vote256 views1 answer
Delete all controls in an area vb
VBA
0 vote222 views1 answer
Vbnet add new ecel sheet
VBA
0 vote239 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote289 views1 answer
How to call gcd in vba
VBA
1 vote238 views1 answer
Vba refresh pivot table
VBA
0 vote287 views1 answer
Vba change active sheet
VBA
0 vote224 views1 answer
Vba copy paste value only
VBA