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

0 vote238 views4 answers
Vgrive,deb
VBA
1 vote238 views1 answer
Excel vba get column number from column name
VBA
0 vote223 views1 answer
VBA Sleep Snippet
VBA
0 vote197 views1 answer
Vba argument is set
VBA
0 vote221 views1 answer
Excel vba join variant array
VBA
3 votes216 views1 answer
Vba make long from two words
VBA
3 votes204 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote219 views1 answer
Do while not vb.net
VBA
3 votes206 views1 answer
Vba make long from two shorts
VBA
0 vote212 views1 answer
Excel vba remove formatting from cell
VBA