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

8 votes261 views1 answer
Excel vba make word from bytes
VBA
0 vote119 views1 answer
Excel vba existence of a file
VBA
6 votes133 views1 answer
Excel vba check if a string only contains letters
VBA
1 vote133 views1 answer
Excel vba first row in range
VBA
1 vote135 views1 answer
How to remove zeros in excel
VBA
1 vote120 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote119 views1 answer
Group controls programmatically vb
VBA
0 vote119 views1 answer
Compare dates vb
VBA
2 votes111 views1 answer
Vba array contains
VBA
0 vote129 views1 answer
Vba change active sheet
VBA