View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I specify the height of a row?

Thanks for the feedback and good luck.


Gord

On Sat, 14 Oct 2006 23:34:59 GMT, Ikke wrote:

Gord Dibben <gorddibbATshawDOTca wrote in
:

In Excel row height is measured in points.

72 points per inch.

24.4mm per inch.

I get .352778 mm per point.

If you want to use VBA to set height in mm

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/...vbawssetrowcol


Thanks for your quick reply!

Ikke


Gord Dibben MS Excel MVP