Excel column autofit?

[dBjason]

Trying to automate a worksheet, would like to know how to autofit column width (like when you double-click inbetween columns) in VBA. Anybody know?

 

[dhulbert]

dbjason

Columns("D").EntireColumn.AutoFit

Bes tway to find things like this is to use the macro recorder to record you doing it then have a look at the code that is generated.

 

[byundt]

Note that AutoFit won't work on merged cells. If this issue is important to you, a much more sophisticated macro is required.