Defining Column Widths

[Guest]

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

 

[Gord Dibben]

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/index.php?d=envbawssetrowcol


Gord Dibben Excel MVP

 

[Don S]

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.aspx?scid=kb;en-us;213422

Don S