column width, row height units

  • Thread starter Thread starter GR
  • Start date Start date
G

GR

Just curious if there is a correlation between column
width, row height and metric units on 1:1 scale print.
i.e. 1 column width unit = ?? mm
 
the Row Height is set in points (each point being a shade less than
0.3528 mm). Column Width is set in number of numeric characters in
the default font (e.g., a width of 10 will allow 10 numeric
characters) and size, and so depends on which font you're using and
the default font size.

In VBA, the .width property uses points, while the .ColumnWidth
property uses # of characters. You can use the CentimetersToPoints
method to do the conversion.

cm = Columns(1).Width/Application.CentimetersToPoints(1)
 
Back
Top