column width Q
 

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


--
earthshaker
------------------------------------------------------------------------
earthshaker's Profile: http://www.excelforum.com/member.php...o&userid=29947
View this thread: http://www.excelforum.com/showthread...hreadid=496439

column width Q
 

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
wrote:


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