Specific Column Width

[khansen97]

Anybody have any code to set a width of a column to a certain value?

I tried the following and it didn't work:

ActiveSheet.Columns("A:A").EntireColumn.Width = 19

thanks!

 

[Zathras]

Use the macro recorder!

Columns("A:A").ColumnWidth = 19

 

[byundt]

khansen97,
Width is a read-only property of the range. It is returned in points.

ColumnWidth is a read/write property of the range. It is the number of standard width characters (like a 0) in the normal style that will fit.

As a fine point, Width can be added up for several columns and the results are the same as a single column having the same apparent (by eye) width. The same cannot be said for the sum of ColumnWidth, which will be a little less than for a single column having the same apparent width.
Brad