Defining Column Widths

Hi i need to define the column widths and heights of the excel worksheets in
cm but it appears that the default measurement is not in cm so how can i go
abt changing the default to be in Centimeters?

Your prompt response will be greatly appreciated
Thank you

Alvin

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

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/...vbawssetrowcol


Gord Dibben Excel MVP

On Wed, 5 Oct 2005 05:15:02 -0700, "Alvin" <[email protected]>
wrote:

>Hi i need to define the column widths and heights of the excel worksheets in
>cm but it appears that the default measurement is not in cm so how can i go
>abt changing the default to be in Centimeters?
>
>Your prompt response will be greatly appreciated
>Thank you

On Wed, 5 Oct 2005 05:15:02 -0700, "Alvin"
<[email protected]> wrote:

>Hi i need to define the column widths and heights of the excel worksheets in
>cm but it appears that the default measurement is not in cm so how can i go
>abt changing the default to be in Centimeters?
>
>Your prompt response will be greatly appreciated
>Thank you


I can't take credit for this (I don't write VBA), but these links may
help:

http://www.mrexcel.com/archive2/43500/50477.htm

http://support.microsoft.com/default...b;en-us;213422

Don S