ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Column and row width (https://www.excelbanter.com/excel-programming/288945-column-row-width.html)

R Doornbosch

Column and row width
 
When I go to adjust the column and row width it say that the width is 12.41,
12.41 WHAT? and how can I change this to inches or centimetres?



Rob van Gelder[_4_]

Column and row width
 

You could use Application.InchesToPoints to convert the values.

Rob


"R Doornbosch" wrote in message
...
When I go to adjust the column and row width it say that the width is

12.41,
12.41 WHAT? and how can I change this to inches or centimetres?





R Doornbosch

Column and row width
 
any idea what the current measurement is?

"Rob van Gelder" wrote in message
...

You could use Application.InchesToPoints to convert the values.

Rob


"R Doornbosch" wrote in message
...
When I go to adjust the column and row width it say that the width is

12.41,
12.41 WHAT? and how can I change this to inches or centimetres?







Rob van Gelder[_4_]

Column and row width
 
Width and ColumnWidth are measured differently.
From the docs:

ColumnWidth:
One unit of column width is equal to the width of one character in the
Normal style. For proportional fonts, the width of the character 0 (zero) is
used.

Width is in Points

Rob


"R Doornbosch" wrote in message
...
any idea what the current measurement is?

"Rob van Gelder" wrote in message
...

You could use Application.InchesToPoints to convert the values.

Rob


"R Doornbosch" wrote in message
...
When I go to adjust the column and row width it say that the width is

12.41,
12.41 WHAT? and how can I change this to inches or centimetres?










All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com