close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()