Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Columnwidth in milimeters?

9 views
Skip to first unread message

Charlotte E.

unread,
May 21, 2013, 6:01:11 AM5/21/13
to
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__

unread,
May 21, 2013, 11:27:17 AM5/21/13
to
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.

Gord Dibben

unread,
May 21, 2013, 1:21:33 PM5/21/13
to
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



On Tue, 21 May 2013 12:01:11 +0200, "Charlotte E." <No...@m.net>
wrote:

Charlotte E.

unread,
May 22, 2013, 2:05:10 AM5/22/13
to
What'a you know - a simple formula could do the trick :-)

Thanks...

CE
0 new messages