How do I make the column widths amp; row heights the same amp; = .25 inches?
I'm using Excel 2002.
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.
www.erlandsendata.no/english/...vbawssetrowcolGord Dibben MS Excel MVP
On Tue, 24 Jan 2006 09:10:02 -0800, Tim gt; wrote:
gt;How do I make the column widths amp; row heights the same amp; = .25 inches?
gt;I'm using Excel 2002.
Gord Dibben MS Excel MVP
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
quot;Gord Dibbenquot; wrote:
gt; Assuming 96 pixels per inch you could approximate but at different resolutions
gt; your approximation can be off.
gt;
gt; If you want to use VBA to set height and width in mm which you can then convert
gt; to inches.
gt;
gt; 25.4 mm per inch
gt;
gt; Ole Erlandson has code for setting row and column dimensions.
gt;
gt; www.erlandsendata.no/english/...vbawssetrowcol
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 24 Jan 2006 09:10:02 -0800, Tim gt; wrote:
gt;
gt; gt;How do I make the column widths amp; row heights the same amp; = .25 inches?
gt; gt;I'm using Excel 2002.
gt;
gt; Gord Dibben MS Excel MVP
gt;
- Nov 18 Sat 2006 20:10
Column widths amp; row heights
close
全站熱搜
留言列表
發表留言