Solved: How Do I Convert Excel Row Height to mm?

[alu]

Hi,

(Sorry not a VBA Q ),

Would like to set the row heights of some tables to 5.989mm (approx), But I just can't to the calculation to convert the Excel unit of measure to mm.

Heres my attempt to calculate it, clearly I am not doing it right, Help would be appreciated (I dont think my numbers are right either...)



Its something like 1pt = 1/72nd of an inch
1inch = 2.54cm
2.54/72 = 0.0353
5.989 / 0.0353 = 169


Thanks all!

[anandbohra]

I dont know your purpose logically but here it is metric table

1 inch = 25.4 mm

[alu]

Thanks anandbohra, But I still can't work out the calculation to turn Excel points into mm (shudda stayed in schooll longer:bug: )

any more ideas anyone? thank you all

[anandbohra]

when I searched over the net I come to know excel one point = 1/72 inch (correct me if I am wrong)
now u want to convert this point to mm
1 inch= 25.4 mm (metric notation)

1 point = 1/72 inch ( got through internet information)

now we want 1 point = ??? mm ( right)

answer is
inch mm
1 25.4
1/72 ???


Cross multiplication which was taught us in school

??? = [(1/72)*25.4]/1

??? = 0.352777777777778 mm

here it is. & again if u convert this mm into points then new equation will be

1/0.352777777777778 mm

u get 2.83464566929134 points (edited afterwords for some misconcet)

[Bob Phillips]

Surely, it is just

=rowheight_in_points /72 *25.4

[alu]

Thanks again anandbohra I was really struggling with that, but I couldnt work out where I was going wrong (:banghead: ) :-p

[jolivanes]

Here are a couple sites to look at.

http://support.microsoft.com/kb/213422
http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol

Good luck

John

[anandbohra]

nice links

Thanks jolivanes

[Aussiebear]

You could try the following link

http://www.exceltip.com/show_tip/Cells,_Ranges,_Rows,_and_Columns_in_VBA/Set_row_height_and_column_width_in_millimeters_using_VBA_in_Microsoft_Excel/489.html