J
J.W. Aldridge
Is there any way I can preset the column width(s) for all new
sheets created in a workbook? Below are the measurements I need.
Columns("a:a").Select
Selection.ColumnWidth = 5.43
Columns("b:b").ColumnWidth = 57.14
Columns("b:b").EntireColumn.AutoFit
Columns("c:c").Select
Selection.ColumnWidth = 6.29
Columns("d:d").Select
Selection.ColumnWidth = 8.43
Columns("e:e").Select
Selection.ColumnWidth = 12.43
Columns("f:f").Select
Selection.ColumnWidth = 12.14
Columns("g:g").Select
Selection.ColumnWidth = 14.14
Columns("h:h").Select
Selection.ColumnWidth = 8
Columns("i:i").Select
Selection.ColumnWidth = 18.57
Columns("j:j").Select
Selection.ColumnWidth = 21.57
Columns("k:k").Select
Selection.ColumnWidth = 4.71
Columns("l:l").Select
Selection.ColumnWidth = 8.43
Thanx.,
sheets created in a workbook? Below are the measurements I need.
Columns("a:a").Select
Selection.ColumnWidth = 5.43
Columns("b:b").ColumnWidth = 57.14
Columns("b:b").EntireColumn.AutoFit
Columns("c:c").Select
Selection.ColumnWidth = 6.29
Columns("d:d").Select
Selection.ColumnWidth = 8.43
Columns("e:e").Select
Selection.ColumnWidth = 12.43
Columns("f:f").Select
Selection.ColumnWidth = 12.14
Columns("g:g").Select
Selection.ColumnWidth = 14.14
Columns("h:h").Select
Selection.ColumnWidth = 8
Columns("i:i").Select
Selection.ColumnWidth = 18.57
Columns("j:j").Select
Selection.ColumnWidth = 21.57
Columns("k:k").Select
Selection.ColumnWidth = 4.71
Columns("l:l").Select
Selection.ColumnWidth = 8.43
Thanx.,