dimensions on spred sheets

[ramilcar]

how do i change the columns dimensions to mm or cm?
to work with some cad software i need to integrate spred sheets and the
columns must be precise. for that at least the wide should be in mm or cm.
thanks for your help

 

[Gord Dibben]

If you want to use VBA to set height and width in mm.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP

 

[Dr. Hay]

The system for row and column dimensions is bullshit. I would guess that
maybe 50,000 people in the USA knows that 72 points is an inch and no one
knows how many letters of any particular font equals one inch.