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 30 Jun 2005 12:05:18 -0700, "drlogarithm" wrote:

How about just marking the edges of the cell, printing out a few cells
and then measuring with a ruler? Let's say the cell is 9.00 wide in
Excel and the print measures to 1/4 of an inch then change the width to
32 for an inch. Simularly, you can do this for the height.