Excel / VBA: auto-adjust column width after pasting data

You can do it with AutoFit:

 Columns("A:B").EntireColumn.AutoFit

You can perform the following:

Columns("A").Autofit