column width Q

[earthshaker]

Is there a way to change the column width measurement from the approx number of characters, to inches?

[Gord Dibben]

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 Wed, 28 Dec 2005 11:00:30 -0600, earthshaker
<[email protected]> wrote:

>
>Is there a way to change the column width measurement from the approx
>number of characters, to inches?