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

Charlotte E. wrote:

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

--
Oh, wait, dotcoms aren't worth anything any more. Never mind.

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

Thanks...

CE


Den 21.05.2013 17:27, Auric__ skrev:
Charlotte E. wrote:

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

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/...vbawssetrowcol


Gord



On Tue, 21 May 2013 12:01:11 +0200, "Charlotte E."
wrote:

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