Q130050 - XL: Macros to Set Row Height and Column Width (in inches or
In the above article, scroll down to see a macro that allows you to specify the row and column widths in centimeters.
Column widths are not really measured in any "unit" as such. Instead, the number refers to the number of characters which can be displayed in the column. For variable width fonts such as Arial, the "0" character is used. In VBA, the ColumnWidth property uses this measure of width, and the Width property uses Points.
This may be useful to you:
1 point = 1/72 inches.
1 inch = 72 points
! point = 0.035 centimeters (or .35 millimetre)