E earthshaker Dec 28, 2005 #1 Is there a way to change the column width measurement from the approx number of characters, to inches?
Is there a way to change the column width measurement from the approx number of characters, to inches?
G Gord Dibben Dec 28, 2005 #2 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
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
