View Single Post
  #2   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?

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


Gord Dibben MS Excel MVP

On Sat, 14 Oct 2006 21:18:11 GMT, Ikke wrote:

Hi everyone,

How can I specify the height of a row in cm?

In Word, when I draw a table, I can specify the height in cm but in Excel I
have not found an option to do so.

Also, when I print the Word document, why are the printed tables not
exactly the size I specify?

Word/Excel 2000...

Thanks in advance,

Ikke