Columnwidth in milimeters?

[Charlotte E.]

Hi,


Is it possible to _READ_ the width of a column in milimeters?

I can get it in chars, pixels and points, but how to get the width of a
column in milimeters???


TIA,

CE

 

[Auric__]

Is it possible to _READ_ the width of a column in milimeters?

I can get it in chars, pixels and points, but how to get the width of a
column in milimeters???

Retrieve it in points, multiply by 25.4, divide by 72:

mm = ActiveCell.Width * 25.4 / 72

 

[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

 

[Charlotte E.]

What'a you know - a simple formula could do the trick

Thanks...

CE


Den 21.05.2013 17:27, Auric__ skrev: