expand column width to the size of the largest value in that column?

Question

In Excel if you double-click a column on its right "border" you can auto-size the width to be the width of the largest value in that column.

How does one replicate this in VBA?

Answer 1

You can use the Macro Recorder to perform the action & see;

<range>.entirecolumn.autofit