changing units
 

Hi, I need to change the size of a cell but they use pixels. can I change
that to inches?

Mindy

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/...vbawssetrowcol


Gord Dibben Excel MVP


On Tue, 19 Apr 2005 21:10:03 -0700, "Mindy"
wrote:

Hi, I need to change the size of a cell but they use pixels. can I change
that to inches?

Mindy

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.

In article ,
Gord Dibben <gorddibbATshawDOTca wrote:

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/...vbawssetrowcol