find your answer here 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