Worksheet.StandardWidth (Excel)

Returns or sets the standard (default) width of all the columns on the worksheet.

One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used.

Worksheets("Sheet1").Columns(1).ColumnWidth = _ 
 Worksheets("Sheet1").StandardWidth