How can I specify the height of a row?
 

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

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

How can I specify the height of a row?
 

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

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

How can I specify the height of a row?
 

1 inch =25.4 mm (NOT 24.4)
This is the DEFINITION of an inch and was adopted in WWII to make US and UK
parts interchangeable
So the US is really metric!
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

How can I specify the height of a row?
 

"Bernard Liengme" wrote in
:

1 inch =25.4 mm (NOT 24.4)
This is the DEFINITION of an inch and was adopted in WWII to make US
and UK parts interchangeable
So the US is really metric!
best wishes

Thank you for the correction!

Ikke

How can I specify the height of a row?
 

Hello, Bernard!
You wrote on Sun, 15 Oct 2006 10:00:25 -0300:

BL 1 inch =25.4 mm (NOT 24.4)
BL This is the DEFINITION of an inch and was adopted in WWII
BL to make US and UK parts interchangeable
BL So the US is really metric!
BL best wishes


Offhand, I don't recall when or why the definition of the inch
was changed but both the British and the American definitions
were very close indeed to 25.4 mm to the inch, close enough that
wrenches were interchangeable. Conveniently for obtaining
agreement on a *definition*, one inch was slightly more than
25.4mm and the other less.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

How can I specify the height of a row?
 

How the hell did 24.4 get into my post?<g

Thanks Bernard for the correction.


Gord

On Sun, 15 Oct 2006 10:00:25 -0300, "Bernard Liengme"
wrote:

1 inch =25.4 mm (NOT 24.4)
This is the DEFINITION of an inch and was adopted in WWII to make US and UK
parts interchangeable
So the US is really metric!
best wishes

Gord Dibben MS Excel MVP