How do I make the column widths & row heights the same & = .25 inches? I'm using Excel 2002.
T Tim Jan 24, 2006 #1 How do I make the column widths & row heights the same & = .25 inches? I'm using Excel 2002.
G Gord Dibben Jan 24, 2006 #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 can then convert to inches. 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 MS Excel MVP How do I make the column widths & row heights the same & = .25 inches? I'm using Excel 2002. Click to expand... Gord Dibben MS 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 can then convert to inches. 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 MS Excel MVP How do I make the column widths & row heights the same & = .25 inches? I'm using Excel 2002. Click to expand... Gord Dibben MS Excel MVP
T Tim Jan 24, 2006 #3 Gord, thank you for your prompt reply. I went to the web site you gave. But I'm not sure how to use the information. I'm not very experienced. I've never tried to write a Macro. Tim
Gord, thank you for your prompt reply. I went to the web site you gave. But I'm not sure how to use the information. I'm not very experienced. I've never tried to write a Macro. Tim
