I want to set my row height to 49.81 but it only does increments of ..25....how do I change this?
C Carl Oct 14, 2004 #1 I want to set my row height to 49.81 but it only does increments of ..25....how do I change this?
G Gord Dibben Oct 14, 2004 #3 Carl That is as close as you get using column width. You do not change it. Row heights are measured in points. There are 72 points to an inch. If you want to use VBA to set height and width in mm....which you then convert to inches. 49.81 points is .691806 inches. ..691806 inches is 17.57187 mm Ole Erlandson has code for setting row and column dimensions in mm http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
Carl That is as close as you get using column width. You do not change it. Row heights are measured in points. There are 72 points to an inch. If you want to use VBA to set height and width in mm....which you then convert to inches. 49.81 points is .691806 inches. ..691806 inches is 17.57187 mm Ole Erlandson has code for setting row and column dimensions in mm http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
