Hi, I need to change the size of a cell but they use pixels. can I change that to inches? Mindy
M Mindy Apr 20, 2005 #1 Hi, I need to change the size of a cell but they use pixels. can I change that to inches? Mindy
G Gord Dibben Apr 20, 2005 #2 Mindy Assuming 96 pixels per inch you could approximate but at different resolutions your approximation can be off. If you want to use VBA to set height and width in mm which you then convert to inches at 25.4 mm per inch.......... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
Mindy Assuming 96 pixels per inch you could approximate but at different resolutions your approximation can be off. If you want to use VBA to set height and width in mm which you then convert to inches at 25.4 mm per inch.......... Ole Erlandson has code for setting row and column dimensions. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP
J JE McGimpsey Apr 20, 2005 #3 One can set column widths and row heights in inches/cm/mm in Excel2004, so perhaps that will be included in the next Windows version.
One can set column widths and row heights in inches/cm/mm in Excel2004, so perhaps that will be included in the next Windows version.
